How to display Power Query results with line feed or carriage return

Although you can inject linefeeds (“#(lf)”) and carriage returns (“#(cr)”) in Power Query, lines will not break in the Excel-display. This simple trick makes your lines break nicely in Excel:

Pic1

  1. Click into the formula bar
  2. Click back into your sheet & the lines will be broken:

pic2

3. Apply that format to the whole column.

4. Make that format stick for future refreshes: Table Tools -> Design -> External Table Data -> Properties -> Check: “Preserve column sort/filter/layout”

Enjoy & stay queryious 🙂

Comments (2) Write a comment

Leave a Reply

Die Datenschutzbestimmungen finden Sie hier: / Please find the privacy policy here: https://wp.me/P6lgsG-Rz