ISTEXT(value)

Returns the value 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 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

 AB
1=ISTEXT("some text") = Truesome text
2=ISTEXT(B1) = True""
3=ISTEXT(B2) = True 
4=ISTEXT(10) = False 
5=ISTEXT(12.345) = False 
6=ISTEXT(B3) = False 

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top