I have a similar problem and went to the page you specified but I'm still not
sure what to do.

MY goal is to take a column of hyperlinks that link to an email address and
convert the hperlingk into the actual email address. Can this be done? I'm
not a programmer.

"Frank Kabel" wrote:

Hi
see:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
in the middle of this page


--
Regards
Frank Kabel
Frankfurt, Germany


JuliaMak wrote:
I have a colum of text.
In each cell in that column, the text is hyperlinked.
I need to somehow extract the hyperlink from the text and put it in
another column. The only way I know to do this is manually.

Is there any way for Excel to do this?