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.

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

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?

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

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

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

- Press Enter -> return value is:

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

- Similarly copying the formula for the remaining values ​​results:

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

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

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

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

Good luck!

4 ★ | 1 Vote