That's good, (only letters no numbers or symbols in 3rd position). I
will try it. Tx.

mikelee101 wrote:
You could use something like this:

=IF(CODE(MID(D3,3,1))<=90,"Upper","Lower")

Where you'd replace "Upper" with what you want it to do if the 3rd character
is upper case and replace "Lower" with what you want it to do if the 3rd
character is lower case.
This assumes that the 3rd character will always be an alpha character (no
numbers or special symbols) and that your computer is using standard ASCII
character set.

Hope that helps.