You might be able to use Excel's HYPERLINK function:

=HYPERLINK(link_location, friendly_name)

Perhaps you could list the URL in Col_A, the display name in Col_B, and
refer to those columns in the formula:

Example:
A1: http://www.msn.com/
B1: MSN
C1: =HYPERLINK(A1,B1)

Does that help?

***********
Regards,
Ron


"basu" wrote:

I have a large excel file and want all product codes to link directly to
images. There are about 3000 of them and doing it manually will take
forever. Is there an easier way?