Thread: Hyperlink help

Okay, here is the setup:
I want to track UPS shipments through excel. I have UPS tracking numbers in column F. I want to have a hyperlink Column G.

This is the hyperlink to make it go directly to the tracking information page.
wwwapps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&InquiryNumber1=1Z1111111111111111
(Whereas the 1Z11111111111111 is the tracking number)

Here is the problem:

In order for this link to go directly to the tracking information, I have to edit the hyperlink and physically type in a new tracking number into that link.

Is there a way to reference the cell that has the tracking number in it and paste that value into the link after the equal sign?

Thanks In Advance

You can use a HYPERLINK formula like:

=HYPERLINK("http://www.apps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&InquiryNumber1="&A1)

where A1 contains the tracking number.

you can add a friendly_name too..

=HYPERLINK("http://www.apps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&InquiryNumber1="&A1,"Tracking # "&A1)