Hi, I need to cut and paste some data from the web into Excel. I'm still using 2003, give me 4 years & I'll be on 2007.

The data contains hyperlinks to the website which I don't want. I can see how to remove this if clicking on one cell and then right clicking "remove hyperlink". Any idea on how to do a whole column's worth in one go? I hope this can be done, its a hell of a lot of right clicking for me otherwise!

Many thanks.