|
|
|
Author |
Message |
petgrubinexcel
|
Posted: Fri Apr 15 13:31:27 CDT 2005 |
Top |
worksheet functions >> 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
Excel107
|
|
|
|
|
CarlosAntenna
|
Posted: Fri Apr 15 13:31:27 CDT 2005 |
Top |
worksheet functions >> deleting internet links
right click on the link and choose "Remove hyperlink"
-- Carlos
> 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
>
>
|
|
|
|
|
gbeard
|
Posted: Fri Apr 15 13:45:50 CDT 2005 |
Top |
worksheet functions >> deleting internet links
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
|
|
|
|
|
CarlosAntenna
|
Posted: Fri Apr 15 14:10:09 CDT 2005 |
Top |
worksheet functions >> deleting internet links
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
> 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
>
>
|
|
|
|
|
gbeard
|
Posted: Fri Apr 15 14:42:56 CDT 2005 |
Top |
worksheet functions >> deleting internet links
Carlos,
Worked like a charm...thanks again for the help!
--
Gary Beard
|
|
|
|
|
CarlosAntenna
|
Posted: Fri Apr 15 14:48:19 CDT 2005 |
Top |
worksheet functions >> deleting internet links
You're welcome, thanks for the feedback.
-- Carlos
> Carlos,
> Worked like a charm...thanks again for the help!
>
> --
> Gary Beard
>
>
|
|
|
|
|
Gord
|
Posted: Fri Apr 15 15:31:04 CDT 2005 |
Top |
worksheet functions >> deleting internet links
Sub Remove_Links()
Selection.Hyperlinks.Delete
End Sub
Gord Dibben Excel MVP
>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,
|
|
|
|
|
Hassan
|
Posted: Mon Apr 18 00:20:20 CDT 2005 |
Top |
worksheet functions >> deleting internet links
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
|
Posted: Mon Apr 18 00:25:44 CDT 2005 |
Top |
worksheet functions >> deleting internet links
Or even shorter, copy an empty cell and paste special and select add
--
Regards,
Peo Sjoblom
> 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..
>
|
|
|
|
|
gbeard
|
Posted: Thu Apr 21 10:22:37 CDT 2005 |
Top |
worksheet functions >> deleting internet links
Great ideas, which both worked...thanks.
--
Gary Beard
|
|
|
|
|
|
|