Cathy -- Unless some of the gurus have an easier idea, you might need to go
with a VLOOKUP function. Basically pretty easy with good documentation.

K L
1 January 1
2 February 2
3 March 3
etc

Then, in your data

A
1 March =VLOOKUP(A1,$K$1:$L$12,2,false)

and that should return the right month number.

HTH

"Cathy" wrote:

I have a column with the month as the full word (January or February, etc.).
I need to translate the words to numbers in a separate column (1 or 2, etc.)
I haven't been able to find a function that can help perform this task. "If"
statements will not go further than 8 levels. The month function will not
recognize it because it's not part of a full date. What other options do I
have? I feel like I'm missing something obvious here...

Thank you,
Cathy