=MID(A1,FIND(",",A1)+2,FIND(" ",A1,FIND(",",A1)+2)-FIND(",",A1)-2)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"George" wrote in message
...
Good Day,
I have a date that I'm pulling from a report that is in a text string
format. What i need to be able to do is extract the month from the string
so
that I can run a script against the month name. The format of the string
is
as follows.
Wednesday, April 14, 2010
Thanks in advance for your help.
Sam