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