ISTEXT function - Function returns True value if that value is text in Excel

ISTEXT function: The function returns True if the value is text. The function application to check if the value is text. Syntax: ISTEXT (value)

The following article introduces you to the ISTEXT function - one of the functions in the information function group is very popular in Excel.

Picture 1 of ISTEXT function - Function returns True value if that value is text in Excel

Description: The function returns True if the value is text. The function application to check if the value is text.

Syntax: ISTEXT (value)

Inside:

- value: The value you want to test is a text or not, is a required parameter.

Attention:

- The function returns True value if that value is text and vice versa returns function False.

- If value is blank or logical -> the function returns False value

For example:

Determine whether the values in the value are text?

Picture 2 of ISTEXT function - Function returns True value if that value is text in Excel

- In the cell to calculate enter the formula : = ISTEXT (C6)

Picture 3 of ISTEXT function - Function returns True value if that value is text in Excel

- Press Enter -> return value is:

Picture 4 of ISTEXT function - Function returns True value if that value is text in Excel

- Similarly copying the formula for the remaining values results:

Picture 5 of ISTEXT function - Function returns True value if that value is text in Excel

- Where value is a blank or logical value -> Function returns false value :

Picture 6 of ISTEXT function - Function returns True value if that value is text in Excel

Above are instructions and some specific examples when using ISTEXT function in Excel.

Good luck!

Update 19 May 2020

You should read it