Expanding Data into multiple columns

[Leen]

Hi
I have a large column containing dates is this format

08/12/2008

I want to put the month in it's own column, the day and the year. Basically
split them up into 3 columns.

I have no idea how to go about it.

 

[Mike H]

Hi.

select the column then
Data|Text to columns
Delimited
Next
Put / in the 'Other' box
Finish

Mike

 

[Leen]

Thanks Mike
That worked except for the month. It broke the day and year out fine in
column B and C, but for the month it listed 1/3/1900 in column A.

 

[Teethless mama]

Format column A as General

Thanks Mike
That worked except for the month. It broke the day and year out fine in
column B and C, but for the month it listed 1/3/1900 in column A.

 

[Dave Peterson]

If they're really dates, you can use:
=year(a1)
=month(a1)
=day(A1)

 

[Leen]

Then it's no longer in date format and the text to columns doesn't work.