Determining the month name base on text in a cell

[PCLIVE]

I've got a cell (A1) with the following contents.

9/1/2005 To 9/30/2005

This cell will always contain from the first to the last day of the month.
However, the month will obviously vary. I'm trying to come up with a
formula in which the result would return the month name that is being
referred to by the cell contents. In this case it would be "September".

Any ideas?

Thanks,
Paul

 

[Don Guillett]

one way of several
=TEXT(VALUE(LEFT(C2,FIND("To",C2)-3)),"mmmm")

 

[PCLIVE]

Thank you Don.
That works great!

Paul

one way of several
=TEXT(VALUE(LEFT(C2,FIND("To",C2)-3)),"mmmm")

 

[Don Guillett]

glad to help