Tildemark blogs

Creating a hyperlink in excel is simple. Notice that after typing any uri in excel the text automatically turned into a hyperlink. You can add any link as you like in excel as long as there is a prepended http:// phrase before the text entered.

Now, what if we are going to add a dynamic URL? It would be best explained by example, so here it goes.

For example: We are asked to check multiple sites for the following internet standards; W3C HTML Validator and WDG HTML Validator.

We have a reference cell A1 have the text http://tildemark.com. We all know the URL for the respective standards as:

W3C - http://validator.w3.org/check?uri=http://www.tildemark.com
WDG - http://www.htmlhelp.com/cgi-bin/validate.cgi?url=http://www.tildemark.com&warnings=yes

Now, all we need to create an entry such that each time we change the domain names the entry on each validator also changes.

Do the following on Excel:

Cell A1 - http://www.tildemark.com

	A	B
1	http://www.tildemark.com
2
3
4
5
...
9	=HYPERLINK ("http://validator.w3.org/check?uri="&A1,"Check W3C HTML Validator")
10	=HYPERLINK ("http://www.htmlhelp.com/cgi-bin/validate.cgi?url="&A9&"&warnings=yes", "Page passed WDG validator")

More info at Office Website .