How do export Excel file to .txt delimited by "^"?
 

I have a text file delimited by ^. I would like to be able to import the
data into Excel, make changes, and export it back into its original format to
upload to State website.

How do export Excel file to .txt delimited by "^"?
 

Does the file have any commas in it?

If not:
You could save it as a CSV (comma seperated) file, and then open it in
notepad, and use Edit: FIND REPLACE to replace the commas with: ^

Careful though: if the file already has commas, this may well mess it up!


"JuliaMK" wrote:

I have a text file delimited by ^. I would like to be able to import the
data into Excel, make changes, and export it back into its original format to
upload to State website.

How do export Excel file to .txt delimited by "^"?
 

Julia

Earl Kiosterud's free TEXTWRITE add-in will do what you want.

http://www.smokeylake.com/excel/text_write_program.htm


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 08:15:02 -0800, JuliaMK
wrote:

I have a text file delimited by ^. I would like to be able to import the
data into Excel, make changes, and export it back into its original format to
upload to State website.

How do export Excel file to .txt delimited by "^"?
 

Just as well to paste into Excel, highlight column:
Data-Text to Columns-Delimited-Other-^

"JuliaMK" wrote:

I have a text file delimited by ^. I would like to be able to import the
data into Excel, make changes, and export it back into its original format to
upload to State website.