Hello to all,


I would like someone to tell me an opinion to a matter that i would like to solve.


I am trying to decode some Barcode serial numbers. I have the solution to decoding successfully each number of the given serial number but i would like to create a function, so when i enter the number (by the barcode scanner), excel will do it automatically for me.


Example.

I have the following Serial number

3LI0732810

3= is the manufacturing plant
L= Year (2012)
I= Month (September)
07=Date (7th)

So imagine it is like this

PYMDD XXXXXXX

another serial number would be

1MA0132807

1= is the plant
M= Year (2013)
A=Month(January)
01=Date (1st)

S/N Plant Manufacturing Date Sequential Unit Number
1MA0132807 USA 1/1/2013 32807
3LI0732810 CHINA 7/9/2012 32807


I thought on using Vlookup, but i prefer if someone can pin point something better

Thank you