tting,*
>>>>
>>>> * *
>>>>
>>>> * *
>>>>
>>>> *Regards*
>>>>
>>>> *Rajan verma*
>>>>
>>>> *+91 7838100659 [IM-Gtalk]*
>>>>
>>>> * *
>>>>
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.**
: 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
; * *
>
> *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*
> ***
>
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 &
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