HyperLinks in Excel. How to remove?

Question

I pasted in a table from a webpage and I need to get rid of the links in one of the columns. Any idea how?

Answer 1

Clicking a cell with hyperlink will run it, so select the range of cells that have that link and press Delete.
OR
Right click on that cell and select "Remove Hyperlink"
OR
Click and hold to select the cell without running the link, then press Delete.

Enjoy my profile, I am the VBAXLMan

Answer 2

u right click on the table and then at the bottom there will be a chocie that say to remove hyper link just click that and it will be gone