Macro to deconstruct and change date string needed

**Aceso** · 01-28-2013, 11:55 AM

I am faced with the challenge of taking dates is this form "January 28 2013" and converting them to the mmddyyyy "01282013" format. If I could move the month to a seperate cell and the day to a seperate cell and then the year to a seperate cell I could concatenate the results to achieve my goal. I can do the year with a LEFT function but don't know how to build the other components.

Guidance is much appreciated!!

**shg** · 01-28-2013, 12:02 PM

If you want to convert that to a date,

=--SUBSTITUTE(A1, " ", ", ", 2)

... and then format as mmddyyyy

If you want a text output in that format,

=TEXT(--SUBSTITUTE(A1, " ", ", ", 2), "mmddyyyy")