+ Reply to Thread
Results 1 to 2 of 2

Hyperlink to a static URL and then include a cell referece

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Hyperlink to a static URL and then include a cell referece

    Hello

    I need to create a Hyperlink to a static URL but then add a cell reference

    The static url is known - www.helloworld.com

    A column in my spreadsheet contains the data needed to add to the end of the static URL - so it would look like www.helloworld.com=(B2)

    I tried this

    =HPYERLINK("www.helloworld.com)+B2,Link - but it is not working :-(



    Greatly appreciate the help

  2. #2
    Registered User
    Join Date
    03-25-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Hyperlink to a static URL and then include a cell referece

    Nobody answer this one, but I finally got it!

    =HYPERLINK(www.helloworld.com)"&B2,"Click Here")

+ 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: 2
    Last Post: 08-12-2013, 06:19 AM
  2. Fill static hyperlink with cell text from different worksheet
    By newnoise in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2011, 11:07 AM
  3. Have cell text fill portion of static hyperlink
    By newnoise in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2011, 11:53 PM
  4. Formula find last used cell and change referece
    By Zaeguzah in forum Excel General
    Replies: 18
    Last Post: 12-23-2009, 07:23 AM
  5. Cell Referece retreval
    By rdmickp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2006, 08:33 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