how to convert 2 lines text into 1 line in a column

[clarawang_12]

Dear community,

My data resource is from excel files from sharepoint folder, and there is one text column, it has 2 lines , how can I convert it into 1 line in each coloumn?  The line breaks is blocking Text Filter Search function.

Best regards,
Clara Wang

[clarawang_12 · Accepted solution]

I have figured it out!  Add Column ->Format -> "Clean" and then line breaks were removed, it is 1 line text now.

[Idrissshatila]

Hello @clarawang_12 ,

You should use extraxt text after delimeter. Refer to this link  for instructions https://radacad.com/extract-parts-of-a-text-value-in-power-bi-using-a-delimiter-power-query-transfor...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin