Change Hyperlink to Plain Text

S

Sam

Column has data that I would like to displayed as plain text to users instead
of having a hyperlink associated with it.

I can do one cell at a time but how would I do an entire column?
 
A

Abode

If you are not familar with working in VBA you can highlight the whole
column, Press Ctrl C to copy the contents. Then rightclick the first row and
click 'paste Special'. Select the 'Values Only' radio button and hit Okay.
That should eliminate all the hyperlinks and leave their text Values.
 
Top