Excel Function : ISTEXT

Download now!

Excel Function : ISTEXT

Category

Information

Description

Returns TRUE if the value is text

Microsoft Excel Reference Page

https://support.office.com/en-us/article/ISTEXT-function-0f2d7971-6019-40a0-a171-f2d869135665

Syntax and Description of the ISTEXT Excel Function

The syntax of the ISTEXT function is as follows: = ISTEXT (value) value is the value that you want to test. The value argument can be any type of data (number, text, date, time, logical value, etc.). If the value is text, the ISTEXT function will return TRUE. If the value is not text, the ISTEXT function will return FALSE. Example Let's see how it works in practice. In the example above, we have a list of values in column A. Some of the values are text, and some are not. In column B, we used the ISTEXT function to test

About ISTEXT Excel Function

The ISTEXT function checks if a value is text and returns TRUE or FALSE.