| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I save Excel am spreadsheet as pipe delimiter?
Google is nice, huh?
Sarah wrote: Thanks Dave. I actually found your post from February after doing more research and it worked great. Thanks again. "Dave Peterson" wrote: One way is to change that list separator. Under the Regional settings Applet under Windows control panel. In winXP, you can click on the Advanced button on the "regional options" tab. Then on the numbers tab, change the list separator character. Remember to change it back when you're done. It's a windows setting and affects other programs. Another option is to write a macro that does exactly what you want. Some sample code to get you started: 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 (Earl's code may do what you want right out of the box.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Sarah wrote: Can anyone tell me if it's possible to save an Excel spreadsheet as a pipe delimiter instead of a tab or comma separated? -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Save To directory doesn't work Excel 2003 | Excel Discussion (Misc queries) | |||
| save spreadsheet as web page | Excel Discussion (Misc queries) | |||
| Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
| My hyperlink in an excel spreadsheet will not save. | Excel Discussion (Misc queries) | |||
| Can't save Excel using Save button, | Excel Discussion (Misc queries) | |||
Threaded Mode
