Forum Discussion
Solved
adding a line break in cell with power query
Hi All, looking for some help to insert line breaks in cells with power query. In column "A" of the attached file is the output of a grouped query in PQ. Whilst i haev added spaces in the text wi...
robwill100 The PQ equivalent for CHAR(10) is #(lf)
robwill100 The PQ equivalent for CHAR(10) is #(lf)
Thanks that saves me a lot of time.
Just a hint to annyone who tries this: #(lf) needs to be quoted to "#(lf)" and the cells in the table need to be formated with Wrap Text
Another hint from over a year later......it is lowercased LF.
