Identify the last character as UPPER or LOWER case

[bobgrand]

Hello all,
I am trying to identify if the last character of the bin location is upper or lower case. I would like to see the answer in column C.

Can anyone shed some light on how to do this? Any help would be greatly appreciated

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ITEM[/TD]
[TD]BIN LOCATION[/TD]
[TD]UPPER/LOWER[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]WIDGET1[/TD]
[TD]01A02B[/TD]
[TD]UPPER[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]WIDGET2[/TD]
[TD]01A06d[/TD]
[TD]LOWER[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]WIDGET3[/TD]
[TD]05B06e[/TD]
[TD]LOWER[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]WIDGET4[/TD]
[TD]10D02B[/TD]
[TD]UPPER[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[JackDanIce]

@Rick Rothstein

Well, that did not come out right.

I did wonder about LOWER"""" and the missing "NUMBER"!

 

[Rick Rothstein]

@Rick RothsteinI did wonder about LOWER"""" and the missing "NUMBER"!

I have no idea what happened... the formula I tested with was correct in the cell, but something went wrong with the copy/paste. I'm guessing something was corrupted somewhere (Excel, Windows, something else?) because I rebooted the computer and tried a test copy (this time paying attention to what was pasted) and it worked fine.

 

[JackDanIce]

I find when I copy from VBE to here, inside the code tags, after I hit return, it seems to "double" some of the white lines I leave in the code, usually near the top and/or bottom but not consistently everywhere. I almost always then edit the post reply to remove those lines and then it looks like it does on my VBE, never understood why that happens!