Excel Power Query: Clear Line-Breaks (A correction to the previous video)

Here’s a quick video correcting 2 things from the previous video: Import Data from Web Page and Clear Line-Breaks

Thanks: Wyn Hopkins, Micheal Reynolds and Chris Pope for pointing these out:
1. There was a single carat delimiter that I missed
2. There’s a way in Power Query (Get and Transform) to separate columns by line-feeds and carriage returns.

Have a look! And thanks for being in the battle against Crap Data.

Also, I mention the Amsterdam MVP Excel Summit. It’s 2 days of Excel MVPS teaching the public the greatest about Excel.
It’s 18 and 19 April. Here’s a link for more details:

Contact me:

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2