Open a csv file in Excel 2010 - a semi colon as the separator
Posted on 2014-09-22
I've downloaded information that is in a csv format, one that uses a semi colon as the separator character. (Commas are part of the real text in a column).
When I try to open it in Excel (a german language version) then it splits into columns based on the comma. Not what I want.
How can I open the csv file and instruct excel 2010 to use a semi colon as the basis for splitting into columns, not the comma.
(I know I could edit the csv file, replace comma with something else then change ; to , and then open it in excel but that would get to be a pain when doing the same thing for file after file....)