In Excel 2010 modify the pasted value to linkClosed

Question

Hello, 



Configuration: Windows 7 / Firefox 11.0 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

pcsces · Answer

Greetings,

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.)

https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator

In Excel 2010 modify the pasted value to link

1 response

Similar discussions

Subscribe To Our Newsletter!