Carriage return in Excel formula, then pasting text into different program; no line breaks

[KeithParker]

Hi Folks,

This is a variant on a problem that others have posted.

I have an Excel formula that concatenates two fields. I would like to have the results separated by a carriage return so that I can then cut and paste the carriage-return lines into a different (non Office) program with the carriage returns.

It just doesn't seem to be working no matter what I try.

Here is what I have tried:

=IF(ISBLANK(H550), "", "Serial: & CHAR(10) & CHAR(13) &" & E550& "Email: " & H550)
=IF(ISBLANK(H550), "", "Serial: & CHAR(10) &" & E550& "Email: " & H550)
=IF(ISBLANK(H550), "", "Serial: & CHAR(13) &" & E550& "Email: " & H550)

Setting the cell to word wrap DOES cause the text to format properly in the cell, but not when pasted into the other program.

Anyone have any thoughts?

KP

[ChemistB]

With text wrap on, this should work

Please Login or Register  to view this content.

Then you would need to copy and Paste Special > Values back to remove the formulas and then paste into the new program. Is that what you are doing?

[KeithParker]

Hi ChemistB,

For the purposes of discussion, let's just say I'm pasting into MS Notepad.

I tried your suggestion. Specifically, here's what I did:

Turned on text wrap on the cell with the formula. Result: text now displays on two lines
Copied the cell
pasted cell contents "as text" into separate cell that already had "text wrap" turned on. Result: no carriage returns
copied contents of cell with the text only into notepad. Results: no carriage returns.

Very baffling. This should be easier.

KP

[ChemistB]

Don't want to paste as text. Paste as values (in same workbook, preferably in same cells). I just checked though and it still doesn't paste properly into notepad. Hmmmmm