cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
RokuCap
Helper I
Helper I

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!

2 REPLIES 2
RokuCap
Helper I
Helper I

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
Solution Specialist
Solution Specialist

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

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

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.