![]() ![]() ![]() The ISNONTEXT function returns TRUE for any non-text value including numbers, dates and times, blanks, and other formulas that return non-textual results or errors. ![]() Where value is a value, cell reference, expression or another function whose result you want to test.įor example, to find out whether a value in A2 is text or not, use this simple formula: For all other data types (such as numbers, dates, blank cells, errors, etc.) it returns FALSE. If the value is textual, the function returns TRUE. The ISTEXT function in Excel checks is a specified value is text or not.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |