Forum Discussion
How to insert line break for text in same cell based on Delimiter?
Say, for example that I have a cell with the following text: "[A] ; [B] ; [C] ; [D]" I would like to add line breaks so that the final loaded output shows each value on separate lines in the same...
Thanks. Adding "#(If)" as the text separator within the Text.Combine Function seems to have done the trick!
Text.Combine( ................. , "#(lf)")
Weird that it doesn't work if I added & "#(If)" as a text string in the Add Column --> Custom Column option.
e.g. [A] & "#(If)" & [B] & "#(If)" & [C] & "#(If)" & [D]