Tag Archives: Line Break

Split cell contents separated by line feed into rows with #Excel #PowerQuery

Posted on May 4, 2019 by MF

After an in-house training, a colleague came to me and asked if there is a way to do the following: The problem here is the contents in cells are separated by a line feed (line break).  A cell may contain … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

Remove Line Break instantly

Posted on July 19, 2014 by MF

Two different ways to replace Line Break with a space QUICKLY If you are trying to build a table of data which is analysis-friendly, DO NOT use line break in your fields and labels.  Otherwise, you will create unnecessary steps … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment