b6f95285_r_not___videos____Office_Blogs__Question
[Answer] You can use a simple macro to automatically extract URLs (e.g., http://www.microsoft.com/en-us/default.aspx) from friendly names (e.g., Microsoft web site). [See for yourself] Video: Show URLs instead of friendly names in pasted text [Question] 
I pasted a large number of links from a web page into Excel, but I only see the display name. How can I show URLs instead of friendly names?
Hyperlinks in Excel: Hot or not? (videos) - Office Blogs
Question