Divide data into multiple cells

[treehstn]

Hi everyone,

I have a large data set that I need to divide up the dates from one column of values into three. This is an image of the current format and the format I need it in. Can anyone help me with the process to do this?

Thanks!

 

[T. Valko]

Yes there are a lot that are in the 1800s... maybe I'll have to change this all by hand?

Ok, we can still do this...

For the month:

=--LEFT(A2,FIND("/",A2)-1)

For the day:

=--SUBSTITUTE(MID(A2,LEN(A2)-6,2),"/","")

For the year:

=--RIGHT(A2,4)

 

[chekree]

Hello,

just split the original column into three by text to column option (in Excel 2007, select the column (ctrl+Space), press Alt, A, E one by one, dont press and hold Alt key), select fixed (column) width--> apply column brakes manually after month and date-->if you want to retain zeros, select all and tick text check box-->press enter. Now, remove slash..

Thats it..

 

[snoopyhr]

Have you tried text to col. and use "/" as delimited character perhaps ?

 

[treehstn]

Awesome! I was able to use a couple of the ideas here and got that part of the project done. One more hurdle but I'll post it separate since it's completely different than this original post.

Thanks everyone!