+ Reply to Thread
Results 1 to 3 of 3

How to insert a cell into a hyperlink... Ex. A2 into A4(www.yahoo.net/A2)

  1. #1
    Registered User
    Join Date
    12-07-2009
    Location
    Detroit
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to insert a cell into a hyperlink... Ex. A2 into A4(www.yahoo.net/A2)

    What I am looking for is a way to put a cells info into a hyperlink..
    Basically I have My Number in the first column, The next column I want to have a link with the Number Cell (A2) as the end of the link Ex.
    <A Href="yahoo.com/A2">Link W/Number</a>

    Any help would be greatly appreciated.
    Im stumped.. I have used these before but without the link...
    Like simple functions, A2+B3... Ex.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to insert a cell into a hyperlink... Ex. A2 into A4(www.yahoo.net/A2)

    Welcome to the Board.

    See the HYPERLINK function in XL Help, example:

    =HYPERLINK("http://www.yahoo.com/"&A2,"Link W/Number")

  3. #3
    Registered User
    Join Date
    12-07-2009
    Location
    Detroit
    MS-Off Ver
    Excel 2003
    Posts
    3

    Solved..Re: How to insert a cell into a hyperlink... Ex. A2 into A4(www.yahoo.net/A2)

    =HYPERLINK("http://mwfb.zynga.com/mwfb/remote/html_server.php?xw_controller=hitlist&xw_action=set&xw_city=3&target_id="&A2,"Alive ???")

    Works like a charm.. Thank you soooooooooooo much..

+ 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