Mark
I don't know if you can do this directly in Excel but it is pretty quick to do it using Excel and Word
1) Save file in Excel as "Text (Tab Deliminated)
2) Close file and select NO on warning message
3) Open text file in Wor
4) If your data was across row 1 then use
Replace>More>Special>Tab Character and enter ; for "replace with
If your data was down column A then use
Replace>More>Special>Paragraph Mark and enter ; for "replace with
5) Select Replace Al
Good Luck
Mark Graesse
(e-mail address removed)
----- Mark Talbot wrote: ----
I need to save a file from Excel 2000 to a text file with
a semi colon delimiter. Can anyone tell me how to do
this