3

How do I find if any letter in a cell is uppercase, for example to identify proper nouns in a word list?

1 Answer 1

6

Just use =NOT(EXACT(LOWER(A1),A1)), replacing A1 with your cell reference. This allows you to check multiple rows at once.

3
  • ...did you just ask and answer your own question within the same minute? Jun 10, 2015 at 8:57
  • 3
    Yes - 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
    @SteveTaylor See Can I answer my own question?
    – gronostaj
    Jun 10, 2015 at 10:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .