Re: $$Excel-Macros$$ Required month name & year from the full date

2012-09-03 Thread Pravin Gunjal
tting,* >>>> >>>> * * >>>> >>>> * * >>>> >>>> *Regards* >>>> >>>> *Rajan verma* >>>> >>>> *+91 7838100659 [IM-Gtalk]* >>>> >>>> * * >>>>

Re: $$Excel-Macros$$ Required month name & year from the full date

2012-09-01 Thread Kuldeep Singh
excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal > *Sent:* 01 September 2012 2:33 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Required month name & year from the full > date > > ** ** > > *Thanks for the reply with solutions.**

RE: $$Excel-Macros$$ Required month name & year from the full date

2012-09-01 Thread Rajan_Verma
: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 01 September 2012 2:33 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required month name & year from the full date Thanks for the reply with solutions. Following i

Re: $$Excel-Macros$$ Required month name & year from the full date

2012-09-01 Thread Pravin Gunjal
; * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal > *Sent:* 01 September 2012 12:58 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Required month name & year from the full date* > *** >

RE: $$Excel-Macros$$ Required month name & year from the full date

2012-09-01 Thread Rajan_Verma
ros@googlegroups.com Subject: $$Excel-Macros$$ Required month name & year from the full date Dear Friends, I have attached an excel file for the subject mentioned above. In which there is column having full date in this format : DD.MM. out of which I required only month name &

Re: $$Excel-Macros$$ Required month name & year from the full date

2012-09-01 Thread ashish koul
TEXT(DATE(RIGHT(A2,4),MID(A2,4,2),1),"-") On Sat, Sep 1, 2012 at 12:57 PM, Pravin Gunjal wrote: > Dear Friends, > > I have attached an excel file for the subject mentioned above. > > In which there is column having full date in this format : DD.MM. > out of which I required only mont