📱How to Find Text in a Cell | COUNTIF in Excel Mobile
Want to check if a cell contains specific text in Excel Mobile? 📱 Learn how to use the COUNTIF function to find words inside a cell on both Excel for Android and Excel for iPhone.
Formula used:
In this example, I use:
=COUNTIF(A6,"*"&$B$5&"*")
This formula returns 1 if the cell contains the word in B5 (like “verdexes”), and 0 if it doesn’t.
Pair it with the IF function to display a YES or NO instead of numbers.
Why the * matters:
The asterisk * is a wildcard that allows Excel to find the text anywhere in the cell, even if there’s other text before or after it.
📹 Related videos:
How to use COUNTIFS the standard way → • 💯 How to Use COUNTIFS Function in Excel | ...
Check if a cell contains text (Microsoft guide) → https://support.microsoft.com/en-us/o...
Excel Mobile Tips → https://snip.ly/561ke1
#exceltutorial #excelmobile #countif #findtext #excelandroid #exceltips #verdexes #excelhelp #shorts