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!

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.

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?

Done and done.

This question has been solved.