MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Saving as Pipe Delimited

Posted by Jim C on February 15, 2002 12:02 PM

I have very large Excel file that I need to get into a pipe delimited format. I can save as tab, comma or space delimited, but I can't figure out Pipe. Is there a way to have excel save in this format. I have thought of using comma delimited and doing a find and replace. This method will mess up parts of my file.


Posted by Dreamboat on February 15, 2002 12:06 PM

Anything against using Word? You can then delimit it with whatever you want. Open the file directly from Word. Click inside the table (which is what you get when you open an Excel file from Word). Hit Table-Select table. Hit Table-Convert Table to text and tell it to use the |

Posted by Mark W. on February 15, 2002 12:13 PM

Save as tab-delimited and then using a system
editor replace the tabs with |. This will
create a .txt file which when opened using
Excel File | Open... menu command will launch
the Text to Columns wizard where you can specify
| as the column delimiter.