Report Offensive Message

improvement on find method
(using 2003)

Ctrl-H to open Replace dialogue
leave Find what: blank
enter whatever you need in Replace with:
open up Options and check Match entire cell contents
Alt-A to invoke Replace All

NB if no range is initally selected, this will update every blank cell in the active area (ie not to IV65536) of the worksheet
Posted by jbenton@...
29th Sep 2011