deleting internet links

[gbeard]

I've copied links from the internet into a sheet. Is it possible to kill
the link and just keep the text in the cell so the text is no longer a link
and no longer underlined?

 

[CarlosAntenna]

right click on the link and choose "Remove hyperlink"

-- Carlos

 

[gbeard]

Thanks Carlos,
It worked great! Is there a way to remove more than one at a time? I've
got a list of a few hundred and I'd like to remove all the links.

Thanks,

 

[CarlosAntenna]

select the entire list
copy
in another location, paste special > values
copy the values and paste back into the original location

i tried to do a paste special in-place but it didn't work

--Carlos

 

[gbeard]

Carlos,
Worked like a charm...thanks again for the help!

 

[CarlosAntenna]

You're welcome, thanks for the feedback.

-- Carlos

 

[Gord Dibben]

Sub Remove_Links()
Selection.Hyperlinks.Delete
End Sub


Gord Dibben Excel MVP

 

[Hassan Alameh]

Yet another simple way:

write in any cell the value of 1, copy it, then select the range with
the hyperlinks,
choose: paste special, multiply..

 

[Peo Sjoblom]

Or even shorter, copy an empty cell and paste special and select add

 

[gbeard]

Great ideas, which both worked...thanks.