Saving as txt file

[Count_Rugen]

I am trying to save an excel worksheet as a txt file that is semi-colo
delimited.
I have done this by inserting a collumn of semi-colons between eac
collumn in my table, then saving it as a text file. The resulting tex
file is ok, however it inserts tabs between each collumn. So instead o
looking like this:

Item1;item2;item3...

it looks like this:

item1 ; item2 ; item3 ...

I need to import this file into another program and it doesnt work i
there are tabs between the collumns
is there anyway that i can save my info in a txt file without thes
tabs?
Thanks
Count Ruge

 

[J.E. McGimpsey]

take a look here:

http://www.mcgimpsey.com/excel/textfiles.html#differentdelimiter

 

[Judy Freed]

You can save the Excel worksheet as a text file, tab delmited. Then open
the file in Word, and use Search and Replace to replace the tabs with
semicolons. We do this all the time.

Judy Freed

I am trying to save an excel worksheet as a txt file that is semi-colon
delimited.
I have done this by inserting a collumn of semi-colons between each
collumn in my table, then saving it as a text file. The resulting text
file is ok, however it inserts tabs between each collumn. So instead of
looking like this:

Item1;item2;item3...

it looks like this:

item1 ; item2 ; item3 ...

I need to import this file into another program and it doesnt work if
there are tabs between the collumns
is there anyway that i can save my info in a txt file without these
tabs?
Thanks
Count Rugen

creating financial statements