Save excel file with pipe separated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I save Excel am spreadsheet as pipe delimiter? 5
Import txt file into excel with 281,344 rows 2
Define Excel delimiter by file extension 1
Export as pipe separated 2
extracting data and text. 2
csv format is wrong in Denmark 3
save as pipe delimited 2
How to perform "ifcount" in many sheets 3

Back
Top