ISTEXT function

This function will test if a value is text and return TRUE if it is text and FALSE if it’s not.

 

Syntax

 

ISTEXT(Value)

  • Value (required) – This is the value you want to test if it’s text.

 

Example

 

In this example we test a few values. Notice that even though a value can contain numbers the result is still text.

=ISTEXT(A2)

ISTEXT

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Subscribe for awesome Microsoft Excel videos 😃

John MacDougall

I’m John, and my goal is to help you Excel!

You’ll find a ton of awesome tips, tricks, tutorials, and templates here to help you save time and effort in your work.

Top Posts

Related Posts

Browse All

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃