How to insert line break for text in same cell based on Delimiter?

[RokuCap]

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!

[RokuCap]

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]

[freginier]

Do you try "Split Column by Delimiter into Rows"?

https://www.excelcampus.com/powerquery/split-into-rows/