INSERTING CELL DATA IN A HYPERLINK

[Guest]

I need to create a hyperlink that will pull info from cells in a worksheet

i.e. - IN THE FOLLOWING HYPERLINK WHICH REPRESENTS THE PAGE I AM CURRENTLY
ON I WOULD NEED TO REPLACE THE WORDS IN ALL CAPS WITH INFORMATION THAT I HAVE
IN SPECIFIC CELLS IN A WORKSHEET

http://www.microsoft.com/wn3/aspx/p...1&sub=INSERTING+CELL+DATA+IN+A+HYPERLINK&pt=1

DOES THIS MAKE ANY SENSE? CAN ANYONE HELP?

 

[Guest]

If A1 contains cnn.com, then:

=HYPERLINK("http://www."&A1,"news")

is an example of making a hyperlink using cell contents.