remove hyperlink but keep friendly name

**DaveKimble** · 12-10-2011, 07:48 PM

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 ?

**tuph** · 12-12-2011, 09:41 PM

It would be helpful if you could attach a copy of your worksheet. Remember to remove or replace any confidential or sensitive data before uploading.

**JBeaucaire** · 12-13-2011, 06:25 AM

You're correct, there is no formula function for this.

To accomplish this you would have to convert your workbook to a macro-enabled workbook and use VBA. You up for that?

**DaveKimble** · 12-13-2011, 09:18 PM

No, I'm not up for VBA, thanks all the same.

It might be an interesting little exercise for someone who is fluent in VBA, and then I could copy it

Consider this CLOSED, thanks.

**JBeaucaire** · 12-13-2011, 10:23 PM

If you want to post up a sample workbook with a range of cells hyperlinked the way you're imagining, then an AFTER sheet showing the results you'd like them converted to, I could take a crack. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.