Check "case" of text

How can I have Excel determine the CASE of data in a certain cell?

Example:
I want to check data in Column 2.
If this data is PROPER case, I want an @ in Column 1.
If the data is UPPER case, I want Column 1 to be blank.

Thanks, in advance, for your help.

Hi,

It assumes the column your looking at is column B. Enter the below in A1 and drag down. Checks each cell.


=IF(EXACT(PROPER(B1),B1)=TRUE,"@",IF(EXACT(UPPER(B1),B1)=TRUE,1,""))

VBA Noob

Thanks VBA Noob!

I was soooo close with the formula I was trying to use.
I didn't have the EXACT function in my formula.

I copy/pasted your formula into my worksheet, and it worked perfectly...almost .
When I pulled the formula down through Column 1...there was a "1" in each cell to the left of UPPER case data.

I simply had to remove the "1" from the end of your formula.

Thanks, again, for your speedy response.

No Problem.

Sorry I thought you wanted a 1 if Upper case. Just missed read your post.

Formula should of being

=IF(EXACT(PROPER(B1),B1)=TRUE,"@","")

VBA Noob