How can you recognize small letters?

Question

excel

Tell me, please, how can I find out all the cells whose words begin with a small letter?

Answer 1

I would use the LEFT, REGEXMATCH and regular expression functions [a-z].

Answer 2

It can be done in bulk if needed. Formula for small latin letters

=ArrayFormula(1=ЕСЛИ(КОДСИМВ(ЛЕВСИМВ(B6:B;1))>=97;1;0)*ЕСЛИ(КОДСИМВ(ЛЕВСИМВ(B6:B;1))<=122;1;0))