Pinterest Pixel

ISTEXT Formula in Excel

Bryan
 .

 

What does it do?

Checks if the cell value is text or not

Formula breakdown:

=ISTEXT(value)

What it means:

=ISTEXT(value to be checked if it is a text or not)


Have a bunch of values and you need to check which ones are text? The ISTEXT Formula in Excel is perfect for this!

There are a couple of interesting points to take note of the ISTEXT Formula:

  • Dates are also treated as numerical values, so the ISTEXT Formula will return FALSE
  • If a number is stored as text, then the ISTEXT Formula will return TRUE

I explain how you can do this below:

ISTEXT Formula in Excel | MyExcelOnline

Download excel workbookISTEXT-FORMULA.xlsx

STEP 1: We need to enter the ISTEXT function in a blank cell:

=ISTEXT(

ISTEXT Formula in Excel

 

STEP 2: The ISTEXT arguments:

Table of Contents

value

What is the value to be checked?

Select the cell containing the value you want to be checked if it is a text:

=ISTEXT(C9)

ISTEXT Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

See also  Change Font to All Caps Quickly: Top 3 Methods

ISTEXT Formula in Excel

You can now see which ones are text!

ISTEXT Formula in Excel

 

How to Use the ISTEXT Formula in Excel

 

 

ISTEXT Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share it



ISTEXT Formula in Excel | MyExcelOnline


Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Steps To Follow

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...