If values of Cell are Null...........

S

Saz

Hi,

If any values of cell in column C are null, how can I update fill null
values to word 'UNKNOWN'?

Thank you,
Saz
 
R

Roger Govier

Hi Saz

Mark the range of column C that you wish to use.
Press F5>Special>Blanks>OK>type unknown into first highlighted cell>press
Control+Enter
 
Top