mid("1164NB1", 5, 2) has a value of "NB"

"Kou Vang" wrote in message
...
How do you extract a certain character from right to left? This is so
simple, yet finding any help code takes me to a million other examples.
Thanks.

1164NB1

How do I extract the "NB" together?