+ Reply to Thread
Results 1 to 6 of 6

Hyperlink to remain a hyperlink

  1. #1
    Registered User
    Join Date
    02-18-2021
    Location
    Quezon City, Philippines
    MS-Off Ver
    2010
    Posts
    7

    Hyperlink to remain a hyperlink

    I need to join some paragraphs, a group of paragraphs that will form a body of an email. There are links that needs to be included in the concatenated texts but hyperlinks doesn't stay as hyperlinks when joined with other texts.

    Can someone please help me as I have been at it for more than 3hrs, have searched the net and YT but can't seem to find anything. Help me, please 😭

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Hyperlink to remain a hyperlink

    Hi Leng09:

    Could you share the structure of your formula; and include the functions used/formatting prefixes if used? OK to abbreviate if it's a mile long.

    Pete

  3. #3
    Registered User
    Join Date
    02-18-2021
    Location
    Quezon City, Philippines
    MS-Off Ver
    2010
    Posts
    7

    Re: Hyperlink to remain a hyperlink

    Hello,

    I attached a file to show how it's supposed to be and the formula I used, apologies it's very basic . I tried using the hyperlink function but still don't seem to work.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Hyperlink to remain a hyperlink

    Hi Leng09:

    Try this in a blank cell in your worksheet:

    (First change googles address in D8 to http://www.google.com, not just www.google.com.)

    Please Login or Register  to view this content.
    Pete
    Last edited by PeteABC123; 01-21-2022 at 05:08 PM.

  5. #5
    Registered User
    Join Date
    02-18-2021
    Location
    Quezon City, Philippines
    MS-Off Ver
    2010
    Posts
    7

    Re: Hyperlink to remain a hyperlink

    Hi Pete,

    I tried the formula you've given, I attached the updated file to show what happened. I don't know if I'm doing something wrong or if I did it correctly but everything became hyperlinked however an error message shows, "Cannot open specified file." when you click it. I also tried a different way but is also not working. I'm using excel 2013 if that matters.

    Edit: Additional note, using VBA is not an option as for some reason, the profile of some of the employees in our department are not compatible with macros enabled files.
    Attached Files Attached Files
    Last edited by Leng09; 01-24-2022 at 09:16 AM.

  6. #6
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Hyperlink to remain a hyperlink

    Quote Originally Posted by Leng09 View Post
    Hi Pete,

    I tried the formula you've given, I attached the updated file to show what happened. I don't know if I'm doing something wrong or if I did it correctly but everything became hyperlinked however an error message shows, "Cannot open specified file." when you click it. I also tried a different way but is also not working. I'm using excel 2013 if that matters.

    Edit: Additional note, using VBA is not an option as for some reason, the profile of some of the employees in our department are not compatible with macros enabled files.
    Try the version that worked for me. The hyperlink is located in C21, and will look like a hyperlink for all text.

    Pete
    Attached Files Attached 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. [SOLVED] VBA loop through column and extract embedded hyperlink and create clickable hyperlink
    By Jay S. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2021, 04:42 PM
  2. userfom load value txtbox hyperlink to cell and create short hyperlink
    By remco77a in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2020, 08:38 AM
  3. Replies: 6
    Last Post: 08-07-2018, 08:43 PM
  4. [SOLVED] Excel 2010 Create a macro to check if cell contains hyperlink then apply hyperlink style
    By chasidar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 04:48 AM
  5. Replies: 1
    Last Post: 02-23-2013, 05:18 AM
  6. Replies: 5
    Last Post: 06-22-2006, 07:10 AM
  7. Replies: 0
    Last Post: 03-26-2006, 07:10 PM

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