Specifying delimiter for Excel 2007 export

Specifying delimiter for Excel 2007 export I'm trying to save an Excel 2007 file as a pipe-delimited text file but in the Save As list, I see only tab-delimited and csv options. How do I go about specifying the delimiter, which as I recall was possible in earlier Excel versions via a wizard?
Asked by: Guest \| Views: 170

Total answers/comments: 2

Comments display order:

Guest [Entry]

"From this page:

Bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.
Click the ""Customize"" button.
Click the “Number” tab and in the “List Separator” field, replace the current default separator with the one you want to use (in your case, the pipe symbol).
Click “OK” to save the change and close the window.

Now exporting as CSV in Excel will produce pipe-delimited files."

Guest [Entry]

"Changing the list separator back and forth is a pain.

Leaving it as | is not acceptable as it screws up a lot of things. Saving as a TAB-separated text file, then using a text editor to globally replace the TABs with |s works well.

To do this with Notepad, highlight a TAB character in the text file, then copy it, then invoke Replace, then paste it into the search for box, then put whatever delimiter you want in the replace with box."