How to change links to regular text

[Just Me]

Hello,

I have a Workbook with a lot of data in the worksheets, all the data in
each cell is a link I want to change it to regular text. I don't know much
about excel so please no advanced solutions please.

Thanks

 

[Pete_UK]

You can fix the values by highlighting the cells with formulae in and
click <copy> then Edit | Paste Special | Values (check) | OK | then
<Esc>.

Hope this helps.

Pete

 

[Just Me]

Didn't work ???

You can fix the values by highlighting the cells with formulae in and
click <copy> then Edit | Paste Special | Values (check) | OK | then
<Esc>.

Hope this helps.

Pete

 

[Dave Peterson]

Select the range
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

 

[Just Me]

Thank you, thank you , thank you !!!

Select the range
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete