Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How to check if a Cell contains a Text in MS Excel

No comments
Its been a while since my last excel tip. Today on my way at the office, I received a call from by brother jayson.

foxtrot: Hello?
Jayson: Kuya, Im doing this excel for my boss and I need to know How to check if a cell contains a text or number?

Excel can easily determine if a particular cell contains text using the IsText function which returns TRUE or FALSE. Here is an example:


=IsText(A1)

If A1 contains a text then it will return TRUE, otherwise it will display FALSE.

You can also beautify the displayed result by using IF statement. For example:


=IF(IsText(A1),"Cell contains Text","Cell contains no Text")

Instead of TRUE or FALSE, the formula above will return a pre-define text display.

No comments :

Post a Comment