save as pipe delimited text file.

Hi,
I have data in excel sheet.
I want to save this as pipe delimited txt file.
Is there any setting by which I can do it?

Thanks,
Aryam

One way could be under Control Panel -> Regional Settings: Customize button - Number Tab - List Seperator, replace the seperator to | (pipe) [per Win XP]

Now save the excel file under CSV format

Thanks Vinod.