+ Reply to Thread
Results 1 to 2 of 2

How do I create a formula that creates a customized hyperlink based on a cell reference?

  1. #1
    Registered User
    Join Date
    11-04-2021
    Location
    Tempe, Arizona
    MS-Off Ver
    Office 2019
    Posts
    1

    How do I create a formula that creates a customized hyperlink based on a cell reference?

    For example, if I had a web address named myexample.com/()data, and a range of excel cells containing the text: 1, 2, 3, 4, and 5.

    How can I reference these cells and add the text from the cells to my hyperlink (myexample.com/()data) to create customized web addresses?

    myexample.com/1data
    myexample.com/2data
    myexample.com/3data
    myexample.com/4data
    myexample.com/5data

    Thank you in advance for your assistance. Also please note I am not experienced in Visual Basic or Javascript.

  2. #2
    Registered User
    Join Date
    11-04-2021
    Location
    Brasil
    MS-Off Ver
    365
    Posts
    2

    Re: How do I create a formula that creates a customized hyperlink based on a cell referenc

    Use the =HYPERLINK() function.

    =HYPERLINK("myexample.com/"&A1&"data").

    Greetings from Brazil.

+ 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. Replies: 1
    Last Post: 09-06-2018, 08:01 AM
  2. [SOLVED] VBA to create Hyperlink to sheet based on Cell value
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2018, 03:51 AM
  3. [SOLVED] Macro to Create Hyperlink with Sheet Name/Cell Reference Message Box
    By yohanmcdonald in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-28-2017, 03:08 PM
  4. Create a formula based on cell reference in another sheet
    By shorcutmasta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2015, 11:52 AM
  5. External cell reference based on hyperlink in a cell in the active sheet
    By Sydstar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2014, 08:25 AM
  6. Create Hyperlink To Worksheet Based On Cell Value
    By Rosco88 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2014, 05:59 AM
  7. How to create a Web Hyperlink based on Cell Contents?
    By chatguy in forum Excel General
    Replies: 2
    Last Post: 10-15-2007, 04:24 PM

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