I have been away from Excel for a while and now I need to create a formula to capture an item number, two digit month, two digit year and an alpha code i.e.
item #: 0001
month: 05
year: 13
alpha code: CS
code result should be 00010513CS
item #: 0002
month: 06
year: 13
alpha code: GC
code result should be 00020613GC
And so on. Does anyone know how to achieve this?
Bookmarks