I just did a test and this worked:
- Hi-light the range of cells you want to find/replace.
- 'Edit'...'replace'...click on the replace tab. In the find window just
leave it blank, in the replace with window enter your formula. Click the
'options' button and check off the match entire cell contents box.
- Click the replace all button.

"Alvin" wrote:

I am trying to repalce all blank cells with a formula but I cannot seem to
figure out how to enter the replace with my formula?