In B2 enter =A2 then custom format as mmmm

Or in B2 enter =TEXT(A2,"mmmm")


Gord Dibben MS Excel MVP

On Thu, 27 Nov 2008 09:30:01 -0800, Liz J
wrote:

I have dates in Column A in this format: MM/DD/YYYY and I would like to
insert a column (column B) that would extract the month indicated in column
A. For example, cell A2 says: 3/19/2008, in cell B2 I would like it to say
"March." How would I do that in Excel?

Thanks for your help!