Saving a spreadsheet with pipe delimiters

  • Thread starter Thread starter John Matlock
  • Start date Start date
J

John Matlock

I have a spreadsheet that I wouuld like to save as a text
file. Instead of delimiting the columns with quotes and
commas, I would like to save it with quotes & pipes (|).

Any ideas?

Thanks in advance for any assistance!

John Matlock
 
You would need a macro for that, should be plenty around if you go to
www.google.com
and search for [export excel pipe delimited text file] or something like
that. Or you can go to control panel regional settings and change the
delimiter from comma to | Open excel again and save the file as a csv file.
Now change the csv to txt and reverse the regional settings to comma again..
 
Back
Top