How to get the URL from the link?

[zizou]

Hi,

I have an Excel table with links in one column. I have to convert thi
table into an SQL table but in the SQL table in the link column onl
the "nice name" appears not the full URL.
I'm thinking that in the Excel I should copy the URLs to another colum
and it'd help. I found the =HYPERLINK() function but I'd need th
reverse function.

Can anyone help me?

Thanx,
ZIzo

 

[Frank Kabel]

Hi
have a look at:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

and search for:
Function to show hyperlink URL used in another cell (#URL)
(in the middle of this page)