MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pipe delimited files

Posted by steve adams on May 17, 2001 1:55 PM

can an Excel file be saved as "pipe" delimited...I have not found a way to do so

Posted by Mark W. on May 17, 2001 2:18 PM

You could save it as a tab-delimited file and
then edit the resulting file replacing all
instances of tab with pipe. Or you could save
it as Formatted Text (.prn) if you don't mind
an additional trailing spaces for each field.
You'd need to use a monospace font such as Courier,
expand all column sizes using AutoFit and insert
a column for each pipe.