Pasting text with double quotes

  • Thread starter Thread starter Bob Anderson
  • Start date Start date
B

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.
 
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.
 
'Paste as HTML' is not an available option, which makes sense since I
originally copied unformatted text.


- Bob A.
 
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.
 
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.
 
Back
Top