ISTEXT

Tests if a cell contains text.

Syntax:

ISTEXT(value)

Returns TRUE if value is or refers to text, and FALSE otherwise.

Example:

ISTEXT(“dog”)

returns TRUE.

ISTEXT(C2)

where cell C2 contains cat returns TRUE.

ISTEXT(C3)

where cell C3 contains =NA() returns FALSE, because NA() returns an error value, not text.

Application:

Customer Feedback Analysis

Imagine you are managing a customer feedback survey for a new product. You have collected data in a spreadsheet, but some customers have accidentally entered numbers or other non-text values in the "Comments" section. You need to quickly identify which cells contain actual text comments for further analysis.

	Customer ID	Product Rating	Comments	ISTEXT(Comments)
	A	B	C	D
1	101	5	Great product, love the new features!	TRUE
2	102	4		FALSE
3	103	3	Needs improvement on the user interface.	TRUE
4	104	5	100% satisfied	TRUE
5	105	2	45	FALSE
6	106	4	#N/A	FALSE
7	107	1	This is not a comment.	TRUE

Explanation:

Row 1 (Customer ID 101): The "Comments" cell contains the text "Great product, love the new features!". The ISTEXT function returns TRUE.
Row 2 (Customer ID 102): The "Comments" cell is empty. The ISTEXT function returns FALSE.
Row 3 (Customer ID 103): The "Comments" cell contains text. The ISTEXT function returns TRUE.
Row 4 (Customer ID 104): The "Comments" cell contains "100% satisfied". Even though it contains numbers, the entire cell's content is interpreted as text, so the function returns TRUE.
Row 5 (Customer ID 105): The "Comments" cell contains only the number 45. The function returns FALSE.
Row 6 (Customer ID 106): The "Comments" cell contains the error value #N/A. The function returns FALSE.
Row 7 (Customer ID 107): The "Comments" cell contains the text "This is not a comment." The function returns TRUE.