embed cell ups tracking # in url

[nikko50]

I have a column filled with UPS tracking #'s. How can I make it so every cell tracking # when clicked goes to the ups site. I know how to right click and use the hyperlink but I don't want to do that for every cell. Below is the UPS url and tracknum is where the cell tracking # would go.

"http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&tracknum=1z9r29a40244572521&AgreeToTermsAndConditions=yes&track.x=17&track.y=4"

 

[Jonmo1]

Try this, where A1 holds your tracking number

=HYPERLINK("http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&tracknum="&A1&"&AgreeToTermsAndConditions=yes&track.x=17&track.y=4",A1)