Open a csv file in Excel 2010 - a semi colon as the separator

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....)
LVL 45
AndyAinscowFreelance programmer / ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Glenn RayExcel VBA DeveloperCommented:
Use the Text Import Wizard to import the CSV file instead.

Sorry, these instructions refer to the English version of Excel 2010, but I presume they will translate to similar functions in German.

1) Open a blank workbook.
2) Excel 2010 Menu: Data, Get External Data section, "From Text"
This will open a browser window that will filter to text and delimited files.  
3) Locate your file and click the "Import" button.
This will display the first screen of the Text Import Wizard
4) Choose "Delimited" on the top and then click the "Next" button.
5) Select "Semicolon" under the "Delimiters" section on top, then click the "Next" button.
6) Define any sections as date or text, as needed, then click the "Finish" button.
This will display a final dialog box
7) Click the "OK" button.

The file should be imported into the blank workbook.

Regards,
-Glenn
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
So that is where it was hidden.
Excellent, thanks
0
Glenn RayExcel VBA DeveloperCommented:
You're welcome.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.