Checks if a value is text and returns TRUE or FALSE.
Синтаксис
ISTEXT(value)Аргументы
valueобязательно
The value you want to test.
The ISTEXT function is a logical function that determines whether the referenced value is a text string. It returns TRUE if the value is text, and FALSE if it is a number, error, logical value, or empty cell.
=ISTEXT("Excel")→TRUEReturns TRUE because the input is a text string.
=ISTEXT(123)→FALSEReturns FALSE because the input is a number.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =ISTEXT(A1) and press Enter, replacing A1 with the cell reference you want to check.
Yes, if a number is stored as text (e.g., with an apostrophe prefix), ISTEXT will return TRUE.