Forum Discussion

RokuCap's avatar
RokuCap
Helper I
3 years ago

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 cell. I.e. Adding line breaks in place of the semi-colons. Does anyone have an idea how to achieve this? I've played around with the "Split Column by Delimiter" function but haven't managed to achieve what I want.

 

"[A]

[B]

[C]

[D]"

 

Thanks in advance!

Need Help

2 Replies

  • RokuCap's avatar
    RokuCap
    Helper I
    3 years ago

    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]