+ Reply to Thread
Results 1 to 3 of 3

Code request to add a double quotation mark at the beginning and at the end

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Code request to add a double quotation mark at the beginning and at the end

    Hi friends,

    In the attached word file there is a piece of html code. I required a double quotation mark at the beginning of the value range ‘b3’ and at the end range ‘b9’.

    Any help will be highly appreciated.

    Thanking you.
    Attached Files Attached Files
    Sincerely,

    mso3

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Code request to add a double quotation mark at the beginning and at the end

    The easiest way (for me) is Chr(34) & Whatever & Chr(34) - this should produce "Whatever"
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Code request to add a double quotation mark at the beginning and at the end

    Hi dflak,
    Perfect! Thank you and have a nice day.

+ 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. [SOLVED] Help with Quotation Mark.
    By bbmak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2014, 12:29 PM
  2. [SOLVED] Quotation Mark Problem?
    By rcoope02 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2013, 04:56 PM
  3. Replies: 3
    Last Post: 07-29-2013, 08:55 AM
  4. [SOLVED] Trouble Storing Double Quotation Mark to Create a String Range
    By stubbsj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 09:21 AM
  5. Quotation mark?
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-09-2008, 10:44 AM
  6. how to use (double) quotation mark as string in codes?
    By ViestaWu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2006, 03:50 AM
  7. joining text and quotation mark
    By yakuzza in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2005, 08:23 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