deleting internet links
 

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?

--
Gary Beard

right click on the link and choose "Remove hyperlink"

-- Carlos

"gbeard" wrote in message
m...
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?

--
Gary Beard

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,
--
Gary Beard

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" wrote in message
. ..
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,
--
Gary Beard

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

--
Gary Beard

You're welcome, thanks for the feedback.

-- Carlos

"gbeard" wrote in message
m...
Carlos,
Worked like a charm...thanks again for the help!

--
Gary Beard

Sub Remove_Links()
Selection.Hyperlinks.Delete
End Sub


Gord Dibben Excel MVP

On Fri, 15 Apr 2005 18:45:50 GMT, "gbeard" wrote:

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,

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..

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

--
Regards,

Peo Sjoblom


"Hassan Alameh" wrote in message
oups.com...
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..

Great ideas, which both worked...thanks.

--
Gary Beard