Hello dear Excel friends,

I am trying to build a forumula to get the result "Jul-12" from the given value "Jul-11"

This is what i tried and I was getting a result "407-12"
not sure if this is a formating issue

Date
Jul-11 =LEFT(A2,3),"-","12"



I know I am wrong. Please help correct me.


Thanks
Excel Dumbo