ISTEXT

ISTEXT(value)

Returns the boolean True or False depending if the value is text.

value

The value you want to test.

REMARKS

* The "value" can refer to a value, cell reference, formula or a named range.
* You can use the TEXT function to return the number as a formatted text string.
* You can use the ISNUMBER function to return True or False depending if the value is a number.
* You can use the ISNONTEXT function is return True or False depending if the value is non text.
* You can use the ISBOLD - User Defined Function function.
* You can use the ISITALIC - User Defined Function function.
* You can use the ISUNDERLINE - User Defined Function function.
* You can use the ISUPPER - User Defined Function function.
* You can use the ISLOWER - User Defined Function function.
* You can use the ISWRAPPED - User Defined Function function.
* You can use the ISPROPER - User Defined Function function.
* You can use the ISMERGED - User Defined Function function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=ISTEXT("4") = True	20
2	=ISTEXT("some text") = True	1/1/2023
3	=ISTEXT(B3) = True	some text
4	=ISTEXT(B4) = True	""
5	=ISTEXT(4) = False
6	=ISTEXT(1.25) = False
7	=ISTEXT(-100) = False
8	=ISTEXT(B1) = False
9	=ISTEXT(B2) = False
10	=ISTEXT(B5) = False
11	=ISTEXT(TRUE) = False
12	=ISTEXT(FALSE) = False

1 - Is the text string "4" text.
2 - Is the text string "some text" text.
3 - Is the value in cell "B3" text.
4 - Is the value in cell "B4" text.
5 - Is the value 4 text.
6 - Is the value 1.25 text.
7 - Is the value -100 text.
8 - Is the value in cell "B1" text.
9 - Is the value in cell "B2" text. This is a date serial number that is displayed as a date.
10 - Is the value in cell "B5" text. This is an empty cell.
11 - Is the value TRUE a number.
12 - Is the value FALSE a number.