Pasting Excel cell contents into Notepad creates quotes 1

[psychozoner]

I am generating multi-line text in a cell, and then copying and pasting it into a Notepad-like application (Notepad displays this same behavior.)
The formula in my cell (H28) is: =H21&CHAR(10)&H26. H21 contents are SET-UP & CLEAN-UP ; H26 contents are GENERAL CLEANUP = 3.0 MIN
H28 appears in Excel as:
SET-UP & CLEAN-UP
GENERAL CLEANUP = 3.0 MIN

but pasting it into my app (and this textbox I am typing this into, as a matter of fact!) appears thus:
"SET-UP & CLEAN-UP
GENERAL CLEANUP = 3.0 MIN"

If I remove the CHAR(10), the quotes go away, but that defeats my purpose of creating the multi-line text. Also, CHAR(13) produced the same results.

Is there anyway, in Excel, to prevent the quotes from being passed on?

Thanks in advance!
Mark

 

[xlbo]

Yes - don't use the CHAR(10) or CHAR(13) characters

The quotes are notepads way of saying that although the data is on 2 lines it came from 1 source

If you want the layout exactly as in excel, you will need to use a seperate cell for each multi-line piece of text...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[psychozoner]

Thank you Geoff! That works. I guess I over-thought it by trying to put everything in one cell. Your way works perfectly!
Thanks again.
Mark