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.