How to paste cell data with a line break without quotation marks (formula data)?

[tonyridino]

Edited:
I've got cell A10 with data:

Apple

Orange


Notice there is a line break in there. When I copy this to another program, it ends up coming out like:


"Apple

Orange"

Is there a way of removing the quotations while keeping the data as is (with the line break) keeping in mind cell A10 is a formula'd cell?

[Aardigspook]

This came up in another thread some time ago (http://www.excelforum.com/excel-gene...-suppress.html). Unfortunately, this happens when you paste from Excel into any program (such as Notepad) which can't parse the line-break formatting (that is, it doesn't 'understand' it). The only way I know of to get round it is to paste the text into a program which can parse it (such as MS Word) and then copy-paste again into where you need it.

Probably not what you wanted to hear, sorry!