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.

That's all very well, but the OP hasn't said the aim is to produce a text file. Besides he's using a Mac, which probably means he's not using Windows and, even if he were, mucking around with the Window's regional settings is not to be lightly advised.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

After his regional settings are set back again, when he opens the csv-file from Excel and saves it as Excel file, all entries will be in column A - separated with semicolons.
This leaves him with the variant B then. Btw. even when his entries originally contain commas, then there is a workaround. Before saving the table as csv-file, he has to replace all commas with some other (unused) chartacter, p.e. "_". And after opening the csv-file and saving it to Excel format, he has to replace this character with comma everywhere again.