How do I replace the hyperlinks on many cells at once?

[Kelly]

I have a spreadsheet of about 4000 rows that I have each row hyperlinked on.
This hyperlink now has an error in it so I was wondering if there is a way to
replace the address in all at once as opposed to replacing them one by one.

 

[Gary''s Student]

Say you have cells with something like:

=HYPERLINK("http://www.cnn.com")

in them. You can use Find / Replace to change cnn to fox in all of them at
once.