Identify if text field is upper or lower case

Hi Erik,

The following will return "Yes" if the first character in cell A2 is uppercase, or else "No" is returned (change these as required):

=IF(EXACT(LEFT(A2,1),UPPER(LEFT(A2,1))),"Yes","No")

HTH

Robert

Trebor76 said:

Hi Erik,

The following will return "Yes" if the first character in cell A2 is uppercase, or else "No" is returned (change these as required):

=IF(EXACT(LEFT(A2,1),UPPER(LEFT(A2,1))),"Yes","No")

HTH

Robert

Click to expand...

Thanks for that.

I also worked it out somehow, albeit, not as concise and as elegant as your solution. I used the 'CODE' command instead of 'EXACT' and compared the ASCII code if LEFT(A2,1) = UPPER(LEFT(A2,1)).

Thanks again. I didn't know about the 'EXACT' command and now I do.

You're welcome