Pasting text with double quotes

[Bob Anderson]

I'm trying to paste text that contains double quotes into Excel.

Example:

"Bob Anderson" 36475tmmn8766

Excel is stripping out the double-quotes upon pasting. I've look
everywhere for an option or setting to override this but have been
unsuccessful.

Does anyone have any ideas?

Thanks


- Bob A.

 

[Bob Anderson]

Some additional info...the stripping only occurs when a double-quote
is the first character in the string. If there is more than one quote
it will strip out the first two it encounters.

 

[CLR]

Try PasteSpecial > As: > HTML

Vaya con Dios,
Chuck, CABGx3

 

[Bob Anderson]

'Paste as HTML' is not an available option, which makes sense since I
originally copied unformatted text.


- Bob A.

 

[Dave Peterson]

If you're doing them one at a time, you could paste into the formula bar.

 

[Bob Anderson]

Unfortunately I have thousands of line to copy from SQL Server Query
Analyzer...there are a couple of ways I can work around it, but it
seems to me there should be a setting in Excel that will solve the
problem. I just haven't been able to find it.

 

[Dave Peterson]

How about a workaround. Convert the double quotes to some character(s) that you
don't use ($$$$), then paste, then edit|replace to revert back.

Paste into notepad first, then do the change, then copy|paste into excel and fix
that change.