+ Reply to Thread
Results 1 to 13 of 13

Pasting text with double quotes

  1. #1
    Bob Anderson
    Guest

    Pasting text with double quotes

    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.

  2. #2
    Bob Anderson
    Guest

    Re: Pasting text with double quotes

    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
    <[email protected]> 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.



  3. #3
    CLR
    Guest

    Re: Pasting text with double quotes

    Try PasteSpecial > As: > HTML

    Vaya con Dios,
    Chuck, CABGx3


    "Bob Anderson" <[email protected]> wrote in message
    news:[email protected]...
    > 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.




  4. #4
    Bob Anderson
    Guest

    Re: Pasting text with double quotes

    '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" <[email protected]>
    wrote:

    >Try PasteSpecial > As: > HTML
    >
    >Vaya con Dios,
    >Chuck, CABGx3
    >
    >
    >"Bob Anderson" <[email protected]> wrote in message
    >news:[email protected]...
    >> 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.

    >



  5. #5
    Dave Peterson
    Guest

    Re: Pasting text with double quotes

    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

  6. #6
    Bob Anderson
    Guest

    Re: Pasting text with double quotes

    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
    <[email protected]> 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.



  7. #7
    Dave Peterson
    Guest

    Re: Pasting text with double quotes

    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
    > <[email protected]> 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

  8. #8
    Registered User
    Join Date
    04-03-2005
    Posts
    1

    Lightbulb Help for displaying quotation marks in a cell

    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.

  9. #9
    Registered User
    Join Date
    11-12-2006
    Posts
    4

    Re: Pasting text with double quotes

    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.
    Last edited by laffo16; 06-24-2011 at 10:43 AM.

  10. #10
    Registered User
    Join Date
    03-10-2015
    Location
    Finland
    MS-Off Ver
    2010
    Posts
    2

    Re: Pasting text with double quotes

    Hi,

    This occurs due to Text To Columns -settings.
    Change TextQualifier to be xlNone and problem is solved.. Unfortunately, his has to be done every time when you open the Excel.

    Selection.TextToColumns Destination:=Range("E4"), DataType:=xlDelimited, _
    TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _
    Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
    :=Array(1, 1), TrailingMinusNumbers:=True

    Do it like this and Excel changes the settings every time you open the Excel:

    Private Sub Workbook_Open()
    Dim ggg As Range

    Set ggg = Cells.Find(What:="*", After:=Range("a1"), LookIn:=xlFormulas, LookAt:= _
    xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
    , SearchFormat:=False)
    If ggg Is Nothing Then
    Set ggg = Range("a1")
    ggg.Value = "x"
    ggg.TextToColumns Destination:=ggg, DataType:=xlDelimited, _
    TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _
    Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
    :=Array(1, 1), TrailingMinusNumbers:=True
    ggg.Value = ""

    Else
    ggg.TextToColumns Destination:=ggg, DataType:=xlDelimited, _
    TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _
    Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
    :=Array(1, 1), TrailingMinusNumbers:=True
    End If

    End Sub

  11. #11
    Registered User
    Join Date
    10-24-2018
    Location
    Indonesia
    MS-Off Ver
    2007
    Posts
    1

    Re: Pasting text with double quotes

    Hi Bob,

    All you need to do is to add a space (yes, only one space) right before the first double quotes on the first row (if you have hundred of rows like mine tonight) of your .txt/.doc file. After that, CTRL+A, CTRL+C, open your excel file, and CTRL+V.

    Tonight, 13 years after you posted this, I found the trick from Pamela Schmidt at microsoft answer

  12. #12
    Registered User
    Join Date
    05-14-2017
    Location
    Austin,Tx
    MS-Off Ver
    2016
    Posts
    1

    Re: Pasting text with double quotes

    --error---
    Last edited by Phil-n-Txt; 06-04-2019 at 05:04 PM.

  13. #13
    Spammer
    Join Date
    06-09-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    149

    Re: Pasting text with double quotes

    Try this:

    Paste with control V.
    After you've pasted with control v, use the little box that pops up and click it's drop down arrow.
    Now, you will see the option for text import wizard. This is different from "paste special."

    Using the text import wizard, on the second screen, change the text qualifier from " to none.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1