In Excel 2010 modify the pasted value to link
Closed
Hello,
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
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
Related:
- In Excel 2010 modify the pasted value to link
- Microsoft office 2010 free download - Download - Office suites
- Pdf and xps add in 2010 - Download - Other
- Number to words in excel - Guide
- Gif in excel - Guide
- Gamevault download link - Download - Online gaming and betting
1 response
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
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
