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:
oz1.depot@gmail.com

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *