remove hyperlinks

[Guest]

After copying a list of assignments from a web scheduling program into Excel,
the personnel names are all hyperlinks back to the original program.

I would like to remove the hyperlinks so that I can manipulate the text. I
know how to do it cell by cell, but is there a way to select a block of cells
and remove the hyperlinks from them all at once?

Thanks for any help!

 

[Ron de Bruin]

You can run this macro also to make text of all hyperlinks
in your worksheet

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run