Is there a way to remove hyperlinks at the the time?

[murphy123]

I have to copy information from a in house website. When I copy the information from the web into an excel spreasheet I copy along with it the data I need its hyperlink. I can't find a way to remove the hyperlink from several records at the time. I have to right click and remove the hyperlink individually. Is there a way that you can remove them the same time?

 

[Gavona]

I think that selecting all the cells, Copy, PasteSpecial, values will convert hyperlink to plain text.



Gavin

 

[murphy123]

Gavin,

You rock! It did work for me!!

Thanks a lot. You saved me a lot of time.