Dynamic Cell URL's from Tracking Numbers

Moderators: Feel free to reloacte please if this is not exactly the right place for this.

Description: I have a worksheet where in 2 columns, tracking numbers (UPS) are pasted. One for Incoming and one for Outgoing. I would like entered text of the tracking number to format itself into a click-able link.

Problem: The way that the UPS site does it's tracking, a full package status url has the tracking number in the middle.

Example: (Please note: Not an Actual URL!)
http://wwwapps.ups.com/WebTracking/p....x=0&track.y=0

As an example: A user enters in the following Tracking Number as plain text: 1A1111AA2222222222

It should then display as 1A1111AA2222222222 in the cell as a click-able link to:
(Please note: Not an Actual URL!)
http://wwwapps.ups.com/WebTracking/p....x=0&track.y=0

How do I make that possible?

I have figured out how to set a =HYPERLINK where it can do so, but then I end up with at best, two columns where it takes the entered tracking number in one cell and puts together the complete URL in the second cell.

I would prefer to have the cell format itself rather like Date/Time etc can be formated.

Is this even possible? If so, how can I accomplish it?

Hi there

If you enter the tracking number in A1, put the below in Cell B1(changing the web address to the proper address but leaving the " & A1 & " as this is where the tracking number will be inserted.

Please Login or Register  to view this content.

Let me know if this is what you were after!

You can just drag this formula down for as many cells as you wish, to do that, hover over the bottom left corner of the cell, you will notice the cursor changes to a cross, click and drag this down for as many cells as you want. The cell value will automatically change. You can then delete the formula from A1 and A2