Text date to date

[T2B]

Is there a function that will convert text dates (month, year)

JULY, 2009
AUGUST, 2009
SEPTEMBER, 2009

to this:

7/1/2009
8/1/2009
9/1/2009

Thanks.

 

[Dave Peterson]

You can use:
=--SUBSTITUTE(A1,","," 1,")
And then format the cell the way you like M/D/YYYY

(and even convert the formula to values if you want to delete the original data)

 

[Don Guillett]

Look in the help index for DATE