saving excel into text problem

M

Mike

I am trying to save an excel sheet text. The sheet is only one column. It
looks like this the cells have data that looks like the following:
md "User Name"
The cells are formatted as text(also have tried general).

When I save to text file, The text file column look like this:
"md ""User Name"""

It adds a bunch of extra quotes.

How Can I avoid this?

Thanks,
Mike
 
D

Dave Peterson

I could save it as a .prn file (space delimited) or a .txt file (tab delimited)
and they both looked ok.

But another way to do this kind of thing (that I think is even easier) is to
copy that column and paste into NotePad. Then save it as a .txt (or .bat) file
from there.
 
Top