Save excel file with pipe separated

V

Vijay Kotian

I would like to save file with "|" (pipe) separation. Normally i save file
with , (comma) separated. How can i save file with pipe separated ? if not
through normal excel even if it is possible with Macro's it is OK.
 
S

smw226 via OfficeKB.com

Hi,

if you want an easy way (and there are no too many columns then

CONCATENATE("A1","|","B1","|"....etc) will get everything into one cell.....
drag that down your entire spreadsheet

paste speacial values

delete the origional data and save that as a .csv

OR (From Microsoft Help:

Click the Windows Start menu.
Click Control Panel.
Open the Regional and Language Options dialog box.
Click the Regional Options Tab.
Click Customize.
Type a new separator in the List separator box.
Click OK twice.



HTH

Simon

Vijay said:
I would like to save file with "|" (pipe) separation. Normally i save file
with , (comma) separated. How can i save file with pipe separated ? if not
through normal excel even if it is possible with Macro's it is OK.
Click to expand...

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200611/1
 
Top