Not in 2008. Go back to Excel 2004 and you can dig it out with VBA.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel If I
have a work that is hyper linked in one cell (A1), is there a way to extract
and print the URL of the linked text in cell A2?
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:
[email protected]