Extracting the Link out of a piece of text.

P

powers

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?
 
J

John McGhie

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?
Click to expand...

--

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is it possible to create a line break 2
Bullets in text cell 1
auto adjust height of cells 6
Value assigned to text 2
cannot enter a long series of numbers without excel changing them. 3
Formulas in Chart Titles Axis Titles 4
Convert numbers stored as text to numbers in excel 2008 3
Extracting Initials from Given names 3

Top