Software

Ask something
Discussion Locked

saving delimited excel document

0 helpful
3 replies

by abailey101

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

3 replies

by dklippert

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.

This discussion is closed to new replies.