Remove the "text to display" in excel

[Trinity765]

Does anyone know how to remove the "text to display" in excel? I know how to do it one by one, but I want to do it for a whole column of data? I just need the link, not the text.

[Trinity765]

FYI, I've tried this macro but it's not working.

The link is something like https://apps.iloveexcel/admin/#/directo ... -521453675

But what I'm getting is https://apps.iloveexcel

Sub Strip_Hyperlink_Names()
Dim HLink As Hyperlink

For Each HLink In ActiveSheet.Hyperlinks
HLink.TextToDisplay = Replace(HLink.Address, "mailto:", "")
Next HLink

End Sub

[Trinity765]

Stand down and thanks if you gave it some thought. Someone did it manually

[Count Steer]

I would have liked to help....but I didn't understand the question.

[Yorick]

My Excel skills were that level 10 years ago.
Retirement has fuddled me brain

[Cousin Jack]

My Excel skills were that level 10 years ago.
Retirement has fuddled me brain

Be fair to yourself, Excel has changed a lot. I used to be pretty damn good (IMO) but I struggle now

[mangocrazy]

Be fair to yourself, Excel has changed a lot. I used to be pretty damn good (IMO) but I struggle now

Mine hasn't; on the main PC I use, I'm still on Office 2003...

[Cousin Jack]

Be fair to yourself, Excel has changed a lot. I used to be pretty damn good (IMO) but I struggle now

Mine hasn't; on the main PC I use, I'm still on Office 2003...

When you are forced to change you will not enjoy the experience!

[mangocrazy]

Be fair to yourself, Excel has changed a lot. I used to be pretty damn good (IMO) but I struggle now

Mine hasn't; on the main PC I use, I'm still on Office 2003...

When you are forced to change you will not enjoy the experience!

I think the Office suite reached peak usefulness around 2003-2007. Ever since then it's just been a case of rearranging the deckchairs and trying to confuse the punters. I've got Office 14, 16 and 18 on other PCs but still prefer 2003. That's on my Windows 7 PC that also boots into various vintages of Kubuntu.

[KungFooBob]

still prefer 2003

Someone's a 'clippy' fan.

[mangocrazy]

still prefer 2003

Someone's a 'clippy' fan.

That was '97, wasn't it? Either way, you can delete clippy and his mates when installing...

[KungFooBob]

2003 was the last version with the 'Office Assistant'

[Yorick]

[mangocrazy]

2003 was the last version with the 'Office Assistant'

Yeah, not disputing that; like I said you could ensure that it wasn't installed when doing a manual install by setting 'Do not install' for Office assistant. But the annoying little twat first surfaced in Office 97.

[Mr. Dazzle]

[Felix]

Becky Excel writes quite amazing gluten free recipes

Was there not meant to be easter eggs hidden in all these versions of Office? If there was i could never find them