How do I find if any letter in a cell is uppercase, for example to identify proper nouns in a word list?
1 Answer
Just use =NOT(EXACT(LOWER(A1),A1))
, replacing A1 with your cell reference. This allows you to check multiple rows at once.
-
...did you just ask and answer your own question within the same minute? Jun 10, 2015 at 8:57
-
3Yes - you can do that via "answer your own question, q&a style". I do this when I have something useful I think people would benefit from. Someone's always surprised. Jun 10, 2015 at 9:20
-
1