Hi Guys,

I have a file with invoice numbers (over 120k). Each invoice number has a prefix (ex. PM1401-121312). Where 14 is the year 2014 & 01 is January month and the rest is the invoice number. So I want to know a formula which would give me the month (in MMM-YY format) next to the invoice number by just taking 1401 into consideration. The prefixes change and so is the spacing and formatting based on the entry done by employees. However, 1401 or 1402 remains the same.

Waiting for a reply.

Thanks

Siyab