Hey yall,
I have a couple of workbooks where I copy/paste data from web sites. Unfortunatly, in the website, the values are all hyperlinked so when I copy/paste it in excel, the hyperlinks come with it. Is there a way to remove all hyperlinks at the same time from the workbook, or even paste-special by disregarding hyperlinks or better yet, have the fields in the workbook all non-hyperlinkable?
Thanks,
Jooquase
I have a couple of workbooks where I copy/paste data from web sites. Unfortunatly, in the website, the values are all hyperlinked so when I copy/paste it in excel, the hyperlinks come with it. Is there a way to remove all hyperlinks at the same time from the workbook, or even paste-special by disregarding hyperlinks or better yet, have the fields in the workbook all non-hyperlinkable?
Thanks,
Jooquase