How do I replace the hyperlinks on many cells at once?
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.
--
Gary''s Student - gsnu200799
"Kelly" wrote:
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.
|