Unwanted Quotes

[pletcherb]

Ok, I don't think this is possible, but I thought I would ask just i
case:

I have a cell with line breaks (pressing ALT+Enter), but when I try t
copy this cell and paste it into another program (like notepad), i
adds quotes around the text! Why? I have no idea, but it is quit
irritating. Any idea how to stop this

 

[mas_detokyo]

If you want to copy it with CTRL+C, I believe you have to clean up the
character by clean function.
e.g. You have text in cell A1 with ALT+ENTER. Then put "=CLEAN(A1)" in
cell B1. Then copy from B1 to another program.
mas

 

[Guest]

With Excel 2003, if you paste into MS Word, you don't get the quotes.

 

[pletcherb]

If you want to copy it with CTRL+C, I believe you have to clean up th
character by clean function.
e.g. You have text in cell A1 with ALT+ENTER. Then put "=CLEAN(A1)" i
cell B1. Then copy from B1 to another program.
mas

That appears to clean out all the line breaks, which I would like t
keep. Thanks for replying though! Any other ideas

 

[pletcherb]

With Excel 2003, if you paste into MS Word, you don't get the quotes.

Hmm, unfortunately I don't want to paste it into Word. I suppose I
could paste it into word, copy it, and then paste it where I want it,
but it would be easier just to remove the quotes after pasting it where
I wanted it. Thanks for the idea though!

 

[Guest]

You are trying to copy from the cell - not good

Instead select the cell and copy directly from the Formula Bar; when you
paste into Notpad the quotes will be missing.


Have a good day!

 

[pletcherb]

You are trying to copy from the cell - not good

Instead select the cell and copy directly from the Formula Bar; when
you
paste into Notpad the quotes will be missing.

Thanks for the idea, but the cell I want to copy from actually contains
a formula. If I copy from the formula bar, I get the formula, not the
value of the formula.

 

[Guest]

Thanks very much for your tip, Gary's Student. I learned something new today!
--
Sincerely, Michael Colvin

You are trying to copy from the cell - not good

Instead select the cell and copy directly from the Formula Bar; when you
paste into Notpad the quotes will be missing.


Have a good day!