Hi Saz

Mark the range of column C that you wish to use.
Press F5SpecialBlanksOKtype unknown into first highlighted cellpress
Control+Enter
--
Regards
Roger Govier

"Saz" wrote in message
...
Hi,

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

Thank you,
Saz