+ Reply to Thread
Results 1 to 7 of 7

HYPERLINK("website/"Cell.Text"website, A4)

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    chair
    MS-Off Ver
    Excel 2003
    Posts
    10

    HYPERLINK("website/"Cell.Text"website, A4)

    Hello,
    I am looking to insert a text string within a hyperlink.

    Please Login or Register  to view this content.
    Let say A4 Cell.text is "Tech".

    So the text within A4 is Tech. And would look like so.

    Now here is the kicker. That link does not go to the "Tech" section of CNN. I want the Hyperlink to read the Cell text and place it within the address.

    So..
    Please Login or Register  to view this content.
    Now the text within A4 not only reads Tech the program will "get" the text and use it within the link.

    Thats step one.

    Now I want to enter that "get" command into the middle of a web address.

    IE: http://en.wikipedia.org/wiki/Stereolab is my website. I want to change the en to de.

    So A4 would read "de" as cell text.A3 could read en.(This will change the language in wiki.)

    Please Login or Register  to view this content.
    How does one do this?

    TIA!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: HYPERLINK("website/"Cell.Text"website, A4)

    Welcome to the forum.

    =HYPERLINK("http://" & A4 & ".wikipedia.org/wiki/Stereolab", "whatever you want to appear in the cell")
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-17-2010
    Location
    chair
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: HYPERLINK("website/"Cell.Text"website, A4)

    Wow! Thank you so much! That is good enough.

    I have one more question.
    I want to quary a number from a website and display that number in a cell.
    The code within the webpage looks like this " <span class="score">5468</span> "
    I want to pull that 5468 and place it in a cell that will refresh when you open/close excell.

    Is there another easy way to do this?
    Thnx again.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: HYPERLINK("website/"Cell.Text"website, A4)

    The ampersand (&) is the catenation operator in Excel. Can't you extend the example to do what you want?

  5. #5
    Registered User
    Join Date
    02-17-2010
    Location
    chair
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: HYPERLINK("website/"Cell.Text"website, A4)

    You answered the Hyperlink question. This is a completely different question.

    I want to query a web page for a certain value it returns. Here is the web page and an example. http://wtfismygearscore.com/gearscore.php?n=Altharus&r=Deathwing&d=EU
    If you view source you see the number is taken from "<span class="score">5012</span>"
    This number updates randomly.I want to take the 5012 and have it inputed into a cell within my excel sheet. (The magenta text is what I need for the first question. "& A4 &")

    I have looked online but the example I found did not explain any coding.
    Is there a simple way to do this?

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: HYPERLINK("website/"Cell.Text"website, A4)

    If it's a completely different question, would you be so kind as to start a completely different thread?

  7. #7
    Registered User
    Join Date
    02-17-2010
    Location
    chair
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: HYPERLINK("website/"Cell.Text"website, A4)

    Done and done.

    This question has been solved.

+ 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