Saving excel file in different format

Question

How do I save an excel workbook as a *.txt file with semi-colon (;) as separators?  I have versions 2003, 2007, 2010 of excel.  The only way I see to save as a *.txt file is the Text (Tab delimiter) option under Save as, but I can't change the "tab" to a semi-colon (;) after it has been converted?  Thanks for any help you can offer.

Colleen

Answer 1

If semi-colon ; is the list separator on your system, you can save the worksheet as a .csv (comma-separated values) file. You can then change the extension of the exported file from .csv to .txt.

---

Regards, Hans Vogelaar

Answer 2

Thanks Hans,

I don't think that a semi-colon (;) can be used in excel as a list separater.  The only choises we are offered are comma (,)  space  or tab.  With the text (tab delimiter) being the only option that will save as a *.txt file.  The only problem with the comma and the space, is that some of the actual text contains commas and spaces that I need to preserve.  Also I don't seem to be able to change the (tab separater) to a semi-colon in notepad.

Colleen

Answer 3

If you have text values, Excel will enclose them in quotes, so that commas shouldn't be a problem.

---

Regards, Hans Vogelaar

Answer 4

CJST you can use my add: XLS to CSV Add-in

Regards

---

Oskar Shon, Office System MVP

Press if Helpful; Answer when a problem solved