Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove Hyperlink
Happy Holidays!
I am copying data from a webpage. Some of the cells are cmoing over as a Hyperlink. Is there any way to strip the link and just leave the text that is transferred from the webpage/ Thanks Janice |
#2
|
|||
|
|||
Take a look at:
http://www.mcgimpsey.com/excel/nohyperlinks.html In article , Janice wrote: Happy Holidays! I am copying data from a webpage. Some of the cells are cmoing over as a Hyperlink. Is there any way to strip the link and just leave the text that is transferred from the webpage/ Thanks Janice |
#3
|
|||
|
|||
Thanks for the response!
I think this is 'backwards'of what I want. That data that I am copying is in table form. Some of the 'cells' in the copy are hyperlinks. When I paste it I want to disable the hyperlink.Thanks Jan "JE McGimpsey" wrote: Take a look at: http://www.mcgimpsey.com/excel/nohyperlinks.html In article , Janice wrote: Happy Holidays! I am copying data from a webpage. Some of the cells are cmoing over as a Hyperlink. Is there any way to strip the link and just leave the text that is transferred from the webpage/ Thanks Janice |
#4
|
|||
|
|||
Did you try it either of the macros in item 4?
In article , Janice wrote: I think this is 'backwards'of what I want. That data that I am copying is in table form. Some of the 'cells' in the copy are hyperlinks. When I paste it I want to disable the hyperlink.Thanks |
#5
|
|||
|
|||
That got it I had some little error I deleted and renetered and it is working
now Thanks so much for your help! Janice "JE McGimpsey" wrote: Did you try it either of the macros in item 4? In article , Janice wrote: I think this is 'backwards'of what I want. That data that I am copying is in table form. Some of the 'cells' in the copy are hyperlinks. When I paste it I want to disable the hyperlink.Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) | |||
How can I extract hyperlink value | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) |