Hi

Use this formula in F1 and copy it down.

=IF(C1,C1,"Unknown")

Regards,
Per

"Saz" skrev i meddelelsen
...
Hi,

How can I copy Copy whole column C to F but if any cell in column C
has null value, it should display as Unknown?

Thank you,
Saz