I have 1000, or more hyperlinks of which the link_location only divers
an id-number somthing like
"http://someonessite.com/docs.php?action=info_id=234" The friendly
names divers to a great extent.

When I copy the links to an excel wks the friendly names show. However
I want to select and sort on the link_location id's to see if
something is missing.

Is there a way to display the link_location?

solutions I tried:
- changing format, no result
- right-clic link, Hyperlink Copy Hyperlink move cursor to empty
cell and paste link. This works, however a lot of clics
- tried to create a macro with the same moves, but than excel copies
the friendly name again.

Anybody has a solution

Thanks

Sfinx59