Text date to date

  • Thread starter Thread starter T2B
  • Start date Start 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.
 
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)
 
Back
Top