Скачать или смотреть Excel Quick Tips - How to remove line breaks using PowerQuery in Excel

Want to know how to remove line breaks using PowerQuery in Excel?

Here's another question: Do you know what a Line Break is called in M Code?

I got this question recently after showing off how to break apart multi-row cells by using text to columns and placing a line break (Ctrl + J) as the delimiter.

The question was - how do you do this in PowerQuery?

Well, turns out it's really easy if you know where to look!

In M (PowerQuery code) a line break is called a Line Feed and you need only go to split columns by delimiter, and choose line feed as the special character to use.

Give it a try!

#excel #nomouseclub #powerquery #shorts

Follow for Excel tips, tricks and more!

📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions:
https://www.tmbanalytics.com/download...

👉 Connect with me on social!
Linkedin:   / mattbrattin  
Tiktok:   / mattbrattin