+ Reply to Thread
Results 1 to 3 of 3

Hyperlink with ampersand in text string name

  1. #1
    Registered User
    Join Date
    10-31-2019
    Location
    Houston, TX
    MS-Off Ver
    365
    Posts
    2

    Question Hyperlink with ampersand in text string name

    I have a hyperlink that references cells in my spreadsheet and then creates an email with the TO: CC: and Subject: lines populated. The issue is that one referenced cell for the subject line may have an ampersand in the name in the text string and the hyperlink will not populate the any part of the name after the ampersand. How can I get Excel to print the exact name with the ampersand?

    EXAMPLE: Cell O1 contains text "Dental/Basic Life/Basic AD&D/Vol Life/Vol AD&D/STD/Vol STD/Vol LTD", the output is "Dental/Basic Life/Basic AD" so everything after the & does not print.
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Hyperlink with ampersand in text string name

    Substitute ampersand with URL encoded string.

    Ex: SUBSTITUTE($O1,"&","%26")
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    10-31-2019
    Location
    Houston, TX
    MS-Off Ver
    365
    Posts
    2

    Re: Hyperlink with ampersand in text string name

    I tried the following but it did not work: "&$B1&"; "&$C1&" &subject= "&$A1&": "&$N1&" - SUBSTITUTE($O1,"&","%26") Annual Account Renewal Request","Carrier Files")

+ 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. When the data SQL retrieves is a string with an ampersand in it...
    By Sidewinder72 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-06-2020, 04:06 AM
  2. Using ampersand to link multiple cells with text
    By mohorter in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2019, 02:44 PM
  3. Ampersand from another sheet and keeping two different text colors VBA
    By zgivod in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2018, 10:03 PM
  4. [SOLVED] Activating a Hyperlink which is a Text String in a Cell
    By hans302 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2018, 01:47 PM
  5. Convert part of string to Hyperlink Text
    By RubberDinero in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-07-2017, 04:36 PM
  6. [SOLVED] Find partial text string within another text string return original text into cell.
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-17-2013, 02:58 PM
  7. Adding Text without using Ampersand?
    By Exxcel Noob in forum Excel General
    Replies: 3
    Last Post: 05-04-2012, 11:47 AM

Tags for this Thread

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