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

Asked By plh on 03-Dec-10 12:09 PM
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:
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.




Dave Peterson replied to plh on 04-Dec-10 01:20 PM
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.




--
Dave Peterson
dranon replied to plh on 06-Dec-10 10:50 PM
You can copy the value of the cell to another cell and then copy/paste
the value.