Block hyperlinks

[jooquase]

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

 

[BAlGaInTl]

You can do a "paste special" and choose "text"

That seems to work for me.