Pasting text with double quotes

Bob Anderson · 03-31-2005, 10:06 PM

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 · 03-31-2005, 10:06 PM

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.

On Thu, 31 Mar 2005 18:30:00 -0800, Bob Anderson
<banderson1962@yahoo.com> wrote:

>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.

CLR · 03-31-2005, 10:06 PM

Try PasteSpecial > As: > HTML

Vaya con Dios,
Chuck, CABGx3

"Bob Anderson" <banderson1962@yahoo.com> wrote in message
news:a9cp41pejhi86q5hklmghppjm3ooi7jk01@4ax.com...
> 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 · 03-31-2005, 11:06 PM

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

- Bob A.

On Thu, 31 Mar 2005 22:01:13 -0500, "CLR" <croberts@tampabay.rr.com>
wrote:

>Try PasteSpecial > As: > HTML
>
>Vaya con Dios,
>Chuck, CABGx3
>
>
>"Bob Anderson" <banderson1962@yahoo.com> wrote in message
>news:a9cp41pejhi86q5hklmghppjm3ooi7jk01@4ax.com...
>> 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.
>

Dave Peterson · 04-01-2005, 01:06 AM

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

Bob Anderson wrote:
>
> 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.

--

Dave Peterson

Bob Anderson · 04-01-2005, 04:06 AM

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.

On Fri, 01 Apr 2005 00:01:10 -0600, Dave Peterson
<ec35720@netscapeXSPAM.com> wrote:

>If you're doing them one at a time, you could paste into the formula bar.
>
>
>
>Bob Anderson wrote:
>>
>> 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.

Dave Peterson · 04-01-2005, 08:06 AM

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.

Bob Anderson wrote:
>
> 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.
>
> On Fri, 01 Apr 2005 00:01:10 -0600, Dave Peterson
> <ec35720@netscapeXSPAM.com> wrote:
>
> >If you're doing them one at a time, you could paste into the formula bar.
> >
> >
> >
> >Bob Anderson wrote:
> >>
> >> 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.

--

Dave Peterson

**peaches3312** · 04-03-2005, 04:47 AM

Hi Bob,

I hope that I have the answer to your problem with using quotation marks. When you put quotation marks around text, that confirms to Excel that you are entering a literal string. You can solve this, at least in Excel 2003, by adding one single quote first:

' "Bob Anderson" 36475tmmn8766

Have a great day!

~Diane

> >Bob Anderson wrote:
> >>
> >> 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.

**laffo16** · 06-24-2011, 10:40 AM

nice 5 year update ^^

to paste text into excel and keep quotation marks (if string begins with quotes)
ie: a string like this...
"Pentium D" 2.66 805

add 3x quotation marks to the begining of the string before pasting. ie
""""Pentium D" 2.66 805

you only need to do this if the string begins with a quote. couldnt find any information about this on net so sry for bumping just trying to find a home for infomation. note directly pasting from above will not work, you'll need to take it into notepad first.