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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Cell 1
Newbie Help - IF Yes No Function 0
How can if statement check multiple cells? 0
Word macro that can call cells out of Excel for a find and replace 0
Nested IF conditions 3
Cell Formating (concatenate two cells) 4
sorting: cleared/null v/s "" 3
VSTO C# add in Outlook.Appointment error 0

Top