Excel 2000
I have a column of cells containing an image-linked hyperlink and a normal hyperlink in them.
I want to have a column of cells with just the friendly name part of the normal hyperlink as text in them.
B1:100 = FRIENDLYNAME(A1)
except that function doesn't exist.

I imagine each cell contains:
<A HREF "http://www.domain.com/.../index.htm"><IMG SRC="..."></A><A HREF="http://....>friendlyname</A>
but I cannot find a way of actually seeing it.
A highlighted cell shows the friendlyname in the formula bar,
but when I use it, the HTML is still there.

How do I get round this ?