Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to unlink links copied from a list from the internet
When I copy the schedule (or results) from the Nascar website and paste it in
excel, the tracks websites (or drivers websites) are attached to the list. I would like to remove the links from each race locations(or driver) so I don't get sent to that website. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to unlink links copied from a list from the internet
hi
i ran into that problem myself with football schedules so i wrote a little macro to run after the paste. just highlight the problem area and run this. Sub removehyperlink() Selection.Hyperlinks.Delete End Sub regards FSt1 "kmjmail" wrote: When I copy the schedule (or results) from the Nascar website and paste it in excel, the tracks websites (or drivers websites) are attached to the list. I would like to remove the links from each race locations(or driver) so I don't get sent to that website. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to unlink links copied from a list from the internet
Hi,
No macro needed. 1. Select an empty cell and choose Copy 2. Select all the cells with links and choose Edit, Paste Special, Add. -- If this helps, please click the Yes button Cheers, Shane Devenshire "kmjmail" wrote: When I copy the schedule (or results) from the Nascar website and paste it in excel, the tracks websites (or drivers websites) are attached to the list. I would like to remove the links from each race locations(or driver) so I don't get sent to that website. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word O7 looses links with excel 07 when files copied to network fr | Links and Linking in Excel | |||
How do I copy a mailing list from the internet to Excel? | Excel Discussion (Misc queries) | |||
How do you sort copied from internet data in Excel? | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
deleting internet links | Excel Worksheet Functions |