Also, there is not always four numbers before the first letter, it could be three or five, etc. I want to have a formula that will find the first letter, and return that letter plus the next two digits (numbers). Thanks.
Create a calculated field with below code. It will extract Alphabet followed by 2 digits and returns the first match.
That worked perfectly, thanks!!!