CONCATENATE involving CHAR(13) and CHAR(10): "" marks when copy/pasteto text editor [???]

P

plh

The result of this formula:
=CONCATENATE("#1=",W4,CHAR(13),CHAR(10),"GOTO665",CHAR(13),CHAR(10),"N5",Y4)
has quotation marks when copy pasted into a text editor, like so:
"#1=2
GOTO665
N553"
You can see that the CR/LF comes out but it adds the quotation marks.
Is there any cure for this?

Thanx,
-plh
PS:
I tried using only CHAR(13) in place of CHAR(13),CHAR(10) and also
CHAR(10) only, and also using cell references in place of the literal
strings, that is:
=CONCATENATE($Y$1,W3,CHAR(13),CHAR(10),$AA$1,CHAR(13),CHAR(10),$Z
$1,Y3)
but the result was the same.
 
D

Dave Peterson

You could use a macro to build the text file the way you want.

You could create a macro that exports the data the way you want.

Here are three sites that you could steal some code from:

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

(or maybe you could build your own formula and copy|paste into Notepad.)

Check out Earl's Text Write program first. It may do exactly what you want
right out of the box.
 
Top