Why does ISTEXT return FALSE for a cell that looks like text?

The cell is likely formatted as a number or date, not text. Check alignment: numbers right-align, text left-aligns by default. Select the cell, format it as Text, and re-enter the value. Then ISTEXT will return TRUE.

Can ISTEXT detect text that looks like a number, such as '123?

Yes. If you type '123 (with a leading apostrophe in Excel), it stores as text and ISTEXT returns TRUE. This is a common data trap—numbers entered as text break SUM() and other calculations.

How do I use ISTEXT to clean a column with mixed text and numbers?

Use FILTER: =FILTER(data, NOT(ISTEXT(data))) extracts only numeric rows, or =FILTER(data, ISTEXT(data)) extracts text rows. Then move results to separate columns to handle each type appropriately.

Does ISTEXT work with formulas that return text?

Yes. If a cell contains =CONCATENATE(A1,B1) producing text, ISTEXT returns TRUE. If the formula returns a number or date, ISTEXT returns FALSE. It checks the result type, not whether a formula exists.

ISTEXT function

Returns TRUE if a value is text, FALSE otherwise. Use ISTEXT to validate data types or filter columns before performing calculations.

=ISTEXT(value)

Generate a ISTEXT formula

Describe what you need. The generator will reach for ISTEXT where ISTEXT is the right tool, and tell you when it is not.

Arguments

How ISTEXT reads its arguments

Argument	Required	Description
value	Required	Any spreadsheet value: text, number, date, boolean, array, or cell reference. Returns FALSE for empty cells, errors, and non-text types.

Returns

Boolean: TRUE if the value is text, FALSE if it's not text (numeric, date, logical, error, or empty).

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Verify an employee name is stored as text

Employee ID	Name	Department	Hire Date	Salary	Status
1001	Alice Johnson	Sales	2020-05-15	65000	Active

=ISTEXT(B2)

Result: TRUE

B2 contains "Alice Johnson", which is text. ISTEXT returns TRUE. This confirms employee names were entered as text values rather than formulas or numbers, ensuring data consistency across your roster.

2. Confirm a salary value is numeric, not text

Employee ID	Name	Department	Hire Date	Salary	Status
1001	Alice Johnson	Sales	2020-05-15	65000	Active

=ISTEXT(E2)

Result: FALSE

E2 contains 65000 stored as a number. ISTEXT returns FALSE, confirming the salary is numeric and safe to use in calculations like SUM() or AVERAGE(). If a salary were entered as text (e.g., "65000"), ISTEXT would return TRUE and flag a data entry error.

3. Validate that employee IDs are numeric, not text

Employee ID	Name	Department	Hire Date	Salary	Status
1001	Alice Johnson	Sales	2020-05-15	65000	Active
1002	Bob Smith	IT	2019-03-22	75000	Active
1003	Carol White	HR	2021-08-10	58000	Active

=IF(ISTEXT(A4),"Error: ID is text","Valid")

Result: Valid

A4 contains 1003 as a number. ISTEXT returns FALSE, so the IF formula returns "Valid". If A4 were entered as "1003" (text), ISTEXT would return TRUE and trigger the error message, helping catch data entry mistakes in employee records.

Common errors

Which ISTEXT error are you seeing?

Error	Why it happens	How to fix it
#NAME?	The function name is misspelled, such as =ISTEX(B2) or =IS_TEXT(B2) instead of =ISTEXT(B2).	Correct the function name to exactly ISTEXT with no underscores or missing letters.
#REF!	The cell reference no longer exists, such as when a column is deleted but the formula still references =ISTEXT(A2) from that column.	Rewrite the formula with a valid cell reference, or undo the deletion of the referenced column.
#VALUE!	The function receives invalid input structure, such as completely malformed range syntax or improper parameter nesting in strict environments.	Verify your formula syntax: =ISTEXT(single_cell) requires exactly one argument with proper cell reference syntax.

Tips and when to use something else

ISTEXT returns FALSE for empty cells, numbers, dates, booleans, and errors—use it to catch when numeric columns accidentally contain text.
Combine ISTEXT with IF or FILTER to validate entire datasets: =FILTER(data, NOT(ISTEXT(salary_column))) returns only properly formatted numeric salary entries.
When text looks like a number (e.g., "123"), ISTEXT returns TRUE—use this to identify entries that need type conversion before math operations.
For opposite behavior, use ISNUMBER to check if a value is numeric, or ISNONTEXT to verify a cell is not text at all.

Related functions

ISNUMBERChecks whether a value is a number, returning TRUE for numeric values and FALSE for text, dates, blanks, and errors.ISNONTEXTISNONTEXT returns TRUE when a value is anything except text—numbers, booleans, dates, or errors—ideal for validating data types in spreadsheets.ISBLANKISBLANK returns TRUE if a cell is completely empty, FALSE if it contains any value or formula, and propagates errors.ISERRORISERROR returns TRUE if a value is an error like #N/A or #REF!, FALSE otherwise, enabling error detection and handling.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.

Frequently asked questions

Why does ISTEXT return FALSE for a cell that looks like text?: The cell is likely formatted as a number or date, not text. Check alignment: numbers right-align, text left-aligns by default. Select the cell, format it as Text, and re-enter the value. Then ISTEXT will return TRUE.
Can ISTEXT detect text that looks like a number, such as '123?: Yes. If you type '123 (with a leading apostrophe in Excel), it stores as text and ISTEXT returns TRUE. This is a common data trap—numbers entered as text break SUM() and other calculations.
How do I use ISTEXT to clean a column with mixed text and numbers?: Use FILTER: =FILTER(data, NOT(ISTEXT(data))) extracts only numeric rows, or =FILTER(data, ISTEXT(data)) extracts text rows. Then move results to separate columns to handle each type appropriately.
Does ISTEXT work with formulas that return text?: Yes. If a cell contains =CONCATENATE(A1,B1) producing text, ISTEXT returns TRUE. If the formula returns a number or date, ISTEXT returns FALSE. It checks the result type, not whether a formula exists.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17