I'm trying to find out if the 1st letter in a cell is UPPERCASE. I know how to convert case using PROPER()
, UPPER()
, and LOWER()
, but not how to detect case.
The following checks every word in the string and returns false
for A1
and true
for A2
, but I just want to know if the 1st character in the cell is proper, not every word.
=EXACT(PROPER(a1),a1)
string in cell A1
:
hello World
string in cell A2
:
Hello World
Any ideas on a formula that will return false
for cell A1
and true
for cell A2
?