pipe delimited format

  • Thread starter Thread starter rick
  • Start date Start date
Here's one way, works well if you only need to do it a couple of times!

Save as a csv.
change the extension of the csv to txt
open the file, select all and copy
paste it into word
use replace to replace "," with "|"
select all, copy and paste back into the text file

If you have to do it numerous times your best bet is a macro, post back if that's what you need

Dan E
 
Another option is to change your windows regional settings.

Windows Start button|settings|control Panel|Regional Settings applet
Number Tab|List separator|(change it to |)

Remember to change it back. It's a windows setting and may affect other
programs.

(Gotta go change mine back.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a flat file in Excel 4
How can I convert tab delimited files to pipe delimited? 2
How can I save Excel am spreadsheet as pipe delimiter? 5
Import Text file with Pipe Delimited - 2007 4
Import Using Pipe as Delimiter 4
Export spreadsheet to .csv 1
export to text file 3
Recognize pipes "|" in when opening a delimited file in Excel 1

Back
Top