Export CSV

[anamarta]

Hello,

I created a table in power bi desktop, and now I'm exporting the data to csv to open the same in excel.

When I opened in excel, the fields that have text with ";" go to other column, and the fields become unformatted.

How can I solve this problem?

Thanks 

[fhill · Accepted solution]

I could not replicate your issue, I wonder if your raw data has carriage returns after each ; character?   Try this to see if you find errors?  

Column = SUBSTITUTE('Table'[Test2],UNICHAR(10),"LineBreak Was Here")

P.S.  Also serach for UNICHAR(9) and UNICHAR(13)