Hi
- select the data range
- hit F5, click 'Special' and choose 'blank cells'
- enter your value and hit CTRL+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany

"wal50" schrieb im Newsbeitrag
...
I have records that have blanks in one field. I want to put the same
value
in all of them. How can I do this? Replace doesn't seem to work for
Blank
fields

wal50