Tag Archives: Line Break

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

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

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