View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sarah
 
Posts: n/a
Default How can I save Excel am spreadsheet as pipe delimiter?

Thanks for your reply Dave. I actually did a little more research after
posting my question and found this post from Dave Peterson back from February
and it worked great.

"What happens if you temporarily change the windows list character from a
comma
to a vertical bar?

windows start button|settings|control panel|Regional settings applet
(or regional and language options)

Click the customize button
Numbers Tab
List separator

(I'd change it back when I was done.)"

"Dave O" wrote:

I don't think it can be done directly- but if you save it as comma
delimited, you could open it in Word or WordPad or some other text
editor, and do a search and replace.

Or you could write some code that reads each line of the file, replaces
commas with pipes, and rights that info to another file. Not too
tricky.