On Monday, August 27, 2012 12:36:51 AM UTC-7, Excel Dumbo wrote:
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









--

Excel

If you format the Jul-11 cell to Number you will get something like 41101.00.
So the Left(A2,3) returns 411. The rest of the example formula is incorrect syntax.

Try this:

'Jul-11 in cell E1.(Note the leading "'"

In destination cell =LEFT(A2,3)&"-"&"12" returns Jul-12

HTH
Regards,
Howard