Identify lower case letters

[bobgrand]

Hello all,

In our bin location structure we use the last character, which could be the 4th, 5th or 6th character to identify which items have more than one bin location.

Is it possible to identify these with a simple Y if the last character is lowercase and N if the last character is uppercase.

Any help would be greatly appreciated.

Bob

 

[ranman256]

if ASC(sLtr) >96 and <122 it is lower case:

asc("a") = 97

 

[Fluff]

How about

=IF(RIGHT(A2,1)=LOWER(RIGHT(A2,1)),"Y","N")

 

[bobgrand]

How about

=IF(RIGHT(A2,1)=LOWER(RIGHT(A2,1)),"Y","N")

Fluff,
Thank you but this is putting a Y on everything
If Lowercase = Y
If Uppercase = N

10D05a = Y
M9A07C = N
10D05b = Y
18A08B = N
10D05a = Y

 

[Fluff]

Ok, how about

=IF(EXACT(RIGHT(A2,1),LOWER(RIGHT(A2,1))),"Y","N")

Also I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)