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
Bookmarks