aa

Module 38: ISNONTEXT Function

38.1 ISNONTEXT Function You can use the ISNONTEXT function in Excel to check whether a value in a cell is not text. ISNONTEXT is part of the function group IS that will return a value of TRUE or FALSE. ISNONTEXT will return a TRUE if the data in a cell is a numeric value, non-logical or any other non-text based value, or FALSE if it is text based. You would use ISNONTEXT with a cell address to provide a value. For example, if you wanted to check whether the value in cell B4 is non...

Lessons

Find out how we can help train your staff

Or buy an individual course

Enquire now