View Single Post
 
Old 03-01-2013, 01:06 AM
ArviL ArviL is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2013
Posts: 11
ArviL is on a distinguished road
Default

A. Set Window's regional settings to some, where semicolon is a list separator (German, Estonian, etc.). (Maybe it will work also, when you set the list separator for your current regional settings to semicolon.) Open your workbook, be sure that the worksheet you want to convert is only one in workbook or at least the first one. Save AS CSV (Comma Delimited).

B. This works when you don't have any commas in your current entries. Open your workbook, be sure that the worksheet you want to convert is only one in workbook or at least the first one. Save AS CSV (Comma Delimited) and close the csv-file. Open the csv-file with notepad, and replace all commas with semicolons. Save.
Reply With Quote