I've downloaded a csv file from a Latin American bank. There are no commas in it - only semicolons. Numbers over a thousand have no commas or decimals in them.



This is information from one cell when I open it in Excel:
60;2014/05/06;6121810;550.46;;RETIRO ATM CTA CTE DIFERENTE MONEDA ;

I've tried changing the semicolons to commas, saving and reopening but then I just get the same thing with commas.

How do I get Excel to turn the semicolons into tabs and display this properly?

Bonus question: How come when I search the Excel forum for "csv" I don't find anything? I can't believe no one has asked question about csv files before.