How to export excel to txt with | separator

**etrader** · 07-16-2009, 05:23 AM

It is possible to save an excel file as csv or tabbed; but how to save an excel file as text file with | separator

**martindwilson** · 07-16-2009, 05:29 AM

save as csv with ,
open with notepad
find replace , with |
perhaps

**etrader** · 07-16-2009, 08:05 AM

The reason that I do not use CSV is that I have "," in my cell contents; thus it is not possible to replace all "," with "|"

**martindwilson** · 07-16-2009, 08:31 AM

ah ! theres a problem then
ok save as tab delimited .csv

then right click and open with word
select all
find ^t
replace |

Re: How to export excel to txt with | separator