Changing separator in CSV file

[Alesek]

Hello, is it possible to change a separator for CSV file in Excel depending on a file? Let's say file A would be separated by comma and file B by semicolon. I know I can change it in region settings in windows, but then I have to keep switching it, which is very annoying

[Alesek]

1 minute ago, Pangea2017 said:

data -> text to columns 

I guess I wrote it incorrectly, I need to be able to save the files with different separators after I created them

[LogicalDrm]

1 hour ago, Pangea2017 said:

Don't know if it can it with macros or simular.

If not use a text editor (notepad++) or own program after saving the file to replace the delimiter or try to use libre office/open office.

 

While this will be annoying if you have huge files (over 10k of replacing), it might be only way with Excel.

[Alesek]

okay, thank you both