Data Transform, Problem with delimiter

[Nastia]

Hello Community,

I encounter one problem with excel. When I export table from csv I have a delimiter semicolon, but it doesn't work. I found solution. If I would go to Power Query Editor - Split Column by delimiter and then change Delimiter from % to ; it will work, but how to change it permanently, I load data all the time with semicolon and it distracts me to change it all the time, because this setting doesn't save and when I load new document I should do this again. How to save the delimiter?

Thank you for the answer!

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Data Transformation, Problem with delimiter

Hello Community, I encounter one problem with excel. When I export table from csv I have a delimiter semicolon, but it doesn't work. I found solution. If I would go to Power Query Editor - Split Column by delimiter and then change Delimiter from % to ; it will work, but how to change it...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[RoryA]

You should specify the delimiter when importing the CSV rather than splitting the column afterwards.

 

[Nastia]

I specified the delimiter on the start, but it didn't worked, the data was messy not all information was split correctly, so I went to transform data and it opened Power Query Editor, here is another option to split it afterwards. When I opened it I saw % as default. I changed it to ; and all started to work. It seems like a bug in excel.