How to get double quotes to show up after pasting?

[Guest]

I need to copy text surrounded by double quotes (for example "example") from
another application and paste it in Excel. After pasting, the double quotes
disappear in Excel, while I don't want that. (pasting "example" results in a
cell showing the word example, while it should be "example").
Does anyone know how I can set up Excel so that it doesn't manipulate the
text string and just pasts it exactly as it is copied to the clipboard?
Appreciate your help.

 

[Guest]

Did you try formatting the cells as 'text' before copying the data into excel?

 

[Guest]

Yes - it doesn't help.
The strange thing is copying "example" from a cell in Excel and pasting in
another cell goes correctly, but pasting from another application Excel
removes the double quotes. I'm pretty sure Excel does this because pasting in
another text editor keeps the double quotes which would indicate the quotes
being there in on the clipboard.
Thanks for your input.