Checking for NULL Values

[JWGoldfinch]

How do I check an excel worksheet to ensure that all cells do not contain a NULL value, there are many cells that should have blanks, but I do not want NULL's so I can export to an iSeries machine

 

[jaybee3]

Define what you mean to be a Null value?

=ISBLANK(A1) will check to see the cell contains any value, if there's a formula that evaluates to a blank then it will be FALSE.

 

[shyy]

Great vid from Mike Girvin

Excel Magic Trick 972: Empty Cell or Null Text String in Formulas: Counting Formulas - YouTube