General discussion

Locked

saving delimited excel document

By abailey101 ·
Is there a way to save an excel document pipe delimited (|). I can save it as a csv file then do a search and replace but There might be a comma in a couple of the fields that could make this impraticle. This also could get time consumming. TAB and Space Delimited are also not an option

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to saving delimited excel do ...

Use the formula
=A1&"|"&B1&"|"&C1
In an empty column. Copy and Paste Special Values
Save the fils as CSV or Tab, but use .DAT as an extension.
When the file is opened, the wizard will request a delimiter.
You could record a macro to do this.

Collapse -

by abailey101 In reply to

Poster rated this answer.

Collapse -

by abailey101 In reply to saving delimited excel do ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums