Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I export XLS to TXT delimited by '|'?
I am trying to export an excel document that I have created to a delimited
text file but it needs to be delimited by the character '|'. The only option that I am getting is tab or comma delimited. Can anyone advise how I can do either using Excel or is there a 3rd party software that can do this? All help much appreciated. |
#2
|
|||
|
|||
http://www.mcgimpsey.com/excel/textfiles.html
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Mohsin Ghani" <Mohsin wrote in message ... I am trying to export an excel document that I have created to a delimited text file but it needs to be delimited by the character '|'. The only option that I am getting is tab or comma delimited. Can anyone advise how I can do either using Excel or is there a 3rd party software that can do this? All help much appreciated. |
#3
|
|||
|
|||
Mohsin,
If you don't want to use a macro, get the Text Write Program from www.smokeylake.com/excel. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Mohsin Ghani" <Mohsin wrote in message ... I am trying to export an excel document that I have created to a delimited text file but it needs to be delimited by the character '|'. The only option that I am getting is tab or comma delimited. Can anyone advise how I can do either using Excel or is there a 3rd party software that can do this? All help much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
Comma delimited bank info | Excel Discussion (Misc queries) | |||
Export to fixed width text file | Excel Discussion (Misc queries) | |||
How do I get data (tables) from IE to export to an EXCEL sreadshee | Excel Discussion (Misc queries) | |||
Export Access Record to Specific Cells in Excel | Excel Discussion (Misc queries) |