Office: Data Transform, 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 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!

 

Moin

Dieses ist ein deutsch-sprachiges Forum.
Aber es gibt auch viele englisch-sprachige Foren.
Hier eine Auswahl:
Excel Help Forum
MrExcel Message Board
Excel