You could use Brad's formula to make it look like the cell was empty
(I'd use "" instead of " " though.)

But if you have a formula, then the cell can't be empty.

But if you're doing something with that cell later, you could always look to see
how it evaluated:
=if(c2="",returnonething,returnanother)

or if you use Brad's:
=if(trim(c2)="","",returnonething,returnanother)



Graham wrote:

Thank you very much Brad that works fine.

Just one thing, is there any way of making C2 have a null value until a part number is entered?

--

Dave Peterson