Hyperlink in Excell

Is this possible!

[union_jack]

In column A is a product name and in column B is a Hyperlink to the product page,

How do you merge the two to get a product name with the hyperlink?

There is over a 1000 so I am looking for a quick fix?

[ukgimp]

[simply-access.com...]

This principle should help

[union_jack]

cheers :)

[union_jack]

Can this be done in Excell or does it have to be in Access for this to work?

[SuzyUK]

In Excel..

in C1 the formula

=HYPERLINK(B1,A1)

where B1 is the link and A1 is the friendly/Product name

Is that it?
Suzy

[union_jack]

That's the one, I love you Suzy.. but don't tell the wife :)

[ukgimp]

you learn something new. Did not know about the hyperlink function.

Cool.