save as pipe delimited

[icestationzbra]

hi,

please help me in this, it is an urgent requirement.

i have an excel file with several columns of data, spanning over 6500
rows.

i would like to extract the data to a file with the data separated wit
a pipe '|' character, instead of tab or comma.

can this be done? if so, how do i go about achieving this?

thanks in advance,

mac

 

[Rehan]

if you are adding columns.. then use CONCATENATE or "&"
to join data in columns.. and you can add '|' character
in between wherever you like..

 

[Dave Peterson]

Here's a couple of links (including Earl's):

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html