Need to delete all hyperlinks on Excel document

W

WDTAHTM

I have a column within which every cell is a hyperlink and want to undo them
all at once
 
K

Ken Wright

Select all, then edit / Copy and Edit / Paste Special values

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top