Text date to date

T

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.
 
D

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)
 
Top