+ Reply to Thread
Results 1 to 3 of 3

how do I concatenate text that has a quotation mark

  1. #1
    Registered User
    Join Date
    07-08-2005
    Posts
    5

    how do I concatenate text that has a quotation mark

    how do I concatenate text that has a quotation mark in it like the following html: <img width="76" height="25" src="blah">

  2. #2
    Dave O
    Guest

    Re: how do I concatenate text that has a quotation mark

    Replace the quotation mark with its ASCII character equivalent: 34.


  3. #3
    Dave Peterson
    Guest

    Re: how do I concatenate text that has a quotation mark

    I put 76 in A1, 25 in B1 and blah in C1.

    Then I used this formula:

    ="<img width="""&A1&""" height="""&B1&""" src="""&C1&""">"

    Seemed to match up ok.

    sparkroms wrote:
    >
    > how do I concatenate text that has a quotation mark in it like the
    > following html: <img width="76" height="25" src="blah">
    >
    > --
    > sparkroms
    > ------------------------------------------------------------------------
    > sparkroms's Profile: http://www.excelforum.com/member.php...o&userid=25037
    > View this thread: http://www.excelforum.com/showthread...hreadid=385642


    --

    Dave Peterson

+ 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