ISTEXT

ISTEXT(value)

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

valueThe 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 user defined ISBOLD function.
* You can use the user defined ISITALIC function.
* You can use the user defined ISUNDERLINE function.
* You can use the user defined ISUPPER function.
* You can use the user defined ISLOWER function.
* You can use the user defined ISWRAPPED function.
* You can use the user defined ISPROPER function.
* You can use the user defined ISMERGED function.
* For the Microsoft documentation refer to support.microsoft.com

 AB
1=ISTEXT("4") = True20
2=ISTEXT("text") = True1/1/2023
3=ISTEXT(B3) = Truetext
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 "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.
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top