Re: $$Excel-Macros$$ Month Code Query

Dear Nikhil, Use *left *function left(a1,3) Regards Sudhir Ingale On Sun, Aug 8, 2010 at 2:48 PM, Nikhil Shah wrote: > Hi Friends, > > I have written In Column " A " ...January ... > > Now I want in Column " B " should be ..Jan ...only...I want formula..( No > Macro ) > > Awaiting Reply > > Tha

Re: $$Excel-Macros$$ Month Code Query

Hi Nikhil You can use function of LEFT Column A Column B January =LEFT(A1,3) On Sun, Aug 8, 2010 at 6:48 AM, Nikhil Shah wrote: > Hi Friends, > > I have written In Column " A " ...January ... > > Now I want in Column " B " should be ..Jan ...only...I want formula..( No > M

Re: $$Excel-Macros$$ Month Code Query

Hi Nikhil you can use =LEFT(A1,3) , i dont knw what exact you looking for but you can enter date in column A cell then go to Format cells-custom select date type as "" then use =TEXT(A1,"mmm") formula in B column so even if you change the month in A column it will show only 3 Alphabet in B co

$$Excel-Macros$$ Month Code Query

Hi Friends, I have written In Column " A " ...January ... Now I want in Column " B " should be ..Jan ...only...I want formula..( No Macro ) Awaiting Reply Thanks Nikhil -- -- Some important links for excel users: