deleting internet links  
Author Message
petgrubinexcel





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: Thu Apr 21 10:22:37 CDT 2005 Top

worksheet functions >> deleting internet links Great ideas, which both worked...thanks.

--
Gary Beard