+ Reply to Thread
Results 1 to 4 of 4

Prevent Double Quotes in formula

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Prevent Double Quotes in formula

    I swear I have done this before without having to escape out anything.

    I have some HTML code split up in multiple cells (some of them have quotes in them)
    I am using =A1&B1&C1&D1 for example..but all instances of quotes are being doubled ... it wasn't doing it before then randomly started. Is there a way to prevent this?

    What is odd is if I copy and paste as values in another spot - it shows without the double quotes, but if I say, copy and paste it into Notepad, now all the double quotes are there???

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Prevent Double Quotes in formula

    I cannot reproduce this. Can you attach a simple file that demonstrates this problem?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Re: Prevent Double Quotes in formula

    This was weird it was something to do with the way I was copy pasting into one of the cells. Instead of pasting normally it was like expanding that row way out and that's what was causing the issue..but I have no clue why.

    I deleted that row then retyped the same stuff again and it worked fine.

    Very odd.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Prevent Double Quotes in formula

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding double quotes for string in formula
    By Vlad717 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-28-2017, 12:42 PM
  2. [SOLVED] Save to a CSV with Double Quotes EXCEPT the Second Column with NO Quotes
    By tkuy2k in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2013, 09:54 AM
  3. Save to a CSV with Double Quotes EXCEPT the First Column with NO Quotes
    By justforthis1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-13-2013, 07:02 PM
  4. [SOLVED] Double Quotes using Chr(34) and Extra Quotes when saving as text file
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-26-2013, 12:26 PM
  5. Export to CSV with double quotes but ignore items that have quotes
    By capnhud in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2010, 03:13 PM
  6. use double quotes in formula
    By achieve in forum Excel General
    Replies: 3
    Last Post: 10-31-2006, 08:19 AM
  7. Setting a cell's value as a formula containing quotes or double quotes using vba
    By Metshrine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2006, 04:10 AM

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