I need to Identify the 10th character of F2 and return the correct year in
cell B2.
For example: F2 VIN# JM1HD4616N0112078 - THE "N" identifies the model year
1992.
I need to recognize the10th digit and place "1992" in the "year" field.

I had trouble with wildcards in the "IF" function, any help would be great!

A B C D E F
1 Stock # Year Description Color Miles VIN #
2 HT58904B MAZDA 929 BLK 36725 JM1HD4616N0112078