Saving as txt file

  • Thread starter Thread starter Count_Rugen
  • Start date Start date
C

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
 
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


Count_Rugen said:
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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top