Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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, |
#8
|
|||
|
|||
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.. |
#9
|
|||
|
|||
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.. |
#10
|
|||
|
|||
Great ideas, which both worked...thanks.
-- Gary Beard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Links to other files | Excel Discussion (Misc queries) | |||
Deleting Links | Links and Linking in Excel | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |