I have one number 181101 - It signifies 18 as YEAR, 11 is the Month (November) and 01 is the batch Number...Excel is extracting Year and Month, as digits, though my requirement is to extract Year as 2018 and Month as Nov. Please help
Solved by I. Y. in 28 mins