In Excel 2010 modify the pasted value to link

 Blocked Profile -

Office 2010 Excel

I often need to record UPS tracking numbers into designated fields in Excel. Is there a way I can paste a tracking number and have it shown as an html link? So click on the link would launch browser and show the tracking info for said tracking number.

I was thinking either an onPaste hookup and examine the pasted value to see if it is like a tracking number, if so, modify the cell accordingly. Or a range of cells with special hookup to accept pasted value and format a link around it

1 reply


Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.