Month & year ONLY from Date+Month+Year

[hsandeep]

How to get only MONTH' YEAR if there is a DATE-MONTH-YEAR in a cell?
A1: 27-July-2012
Answer D1:JULY' 2012
Pl note "' " is suffixed after JULY (the month).

 

[sdsurzh]

Hi,


Try this.


=TEXT(A1,"MMMM YYYY")


Thanks,
SK

 

[hsandeep]

Answer gives July 2012. Can i get July' 2012

 

[Oeldere]

Untested try this one =TEXT(A1,"MMMM"&"'"&"YYYY")

 

[sdsurzh]

=text(a1,"mmmm' yyyy")