Other symbols for delimiter other than TAB

[Daniel]

Dear all,

Hope you can assist me on this matter:

How do I program the Excel so that if I save it as a text
file the ! symbol (or any other symbol) is the delimiter
instead of the TAB?

Currently what I do is:
1. Copy all the cells and an additional blank cell after
the last.
2. Paste into Wordpad.
3. Copy the TAB; run the Replace All command and replace
the TAB with the symbol of my choice.

Is there a way to automate so that when I save the
spreadsheet into text format, it will automatically use my
symbol instead of the TAB? If there is a way, can you show
me how to program it?

Sample:

(Current format if I save as text)
<data>TAB<data>TAB<data>
<data>TAB<data>TAB<data>

(Desired format if I save as text)
<data>!<data>!<data>!
<data>!<data>!<data>!

Believe me, your help is
highly/extremely/incredibly/totally appreciated.

Thanks!

Daniel

 

[Bernard V Liengme]

Hi Daniel,

On Sheet2 use =Sheet1!A1&"!"&Sheet!B1&"!"&Sheeet1!C1&"!"&Sheet1!D1
Save Sheet2 as text file.
Bernard

 

[Dave Peterson]

If you want a macro approach (instead of the worksheet formulas Bernard
suggested), you may want to try Earl Kiosterud's Text Write program:

It's available at Tushar Mehta's site:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Or maybe write your own:
Chip Pearson has some nice get-started code at:
http://www.cpearson.com/excel/imptext.htm