Convert Excel Date to Text in another cell

[duaneo1]

This is probably a simple request.
We want to enter a date in cell A1. We happen to be using the format of "September 20, 2002". In cell A2, we want the MONTH and YEAR of the date in A1 to be displayed, in the format of: "SEPTEMBER 2002".

We appreciate any help. (first-time post)

 

[IML]

Please put this formula in any blank cell on your sheet, and post back the result.

=isnumber(a1)

 

[Mark W.]

=UPPER(TEXT(A1,"mmmm yyyy"))
This message was edited by Mark W. on 2002-09-20 14:59

 

[IML]

If the answer to the formula above is true, use Mark's formula. If false,
either
=LEFT(A1,FIND(" ",A1))&RIGHT(A1,4)
or
=TRIM(REPLACE(A1,FIND(" ",A1),4," "))

should work.

good luck

 

[Mark W.]

IML, my formula works regardless of the data type... thank's to good ol' coercion.
This message was edited by Mark W. on 2002-09-20 15:08

 

[IML]

As always, good to know.

Note to self: try first, suggest second.

 

[mattyb1970]

Thanks guys, I have been on this site for less than a hour and solved one of my problems.

Cheers
Matt