ExcelBanter - If values of Cell are Null...........

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - If values of Cell are Null........... (https://www.excelbanter.com/new-users-excel/185060-if-values-cell-null.html)

Saz

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

Hi,

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

Thank you,
Saz

Roger Govier[_3_]

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

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

All times are GMT +1. The time now is 07:22 PM.