Expanding Data into multiple columns
 

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.
--
Thank You
Leen

Expanding Data into multiple columns
 

Hi.

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

Mike
"Leen" wrote:

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.
--
Thank You
Leen

Expanding Data into multiple columns
 

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.


--
Thank You
Leen


"Mike H" wrote:

Hi.

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

Mike
"Leen" wrote:

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.
--
Thank You
Leen

Expanding Data into multiple columns
 

Format column A as General


"Leen" wrote:

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.


--
Thank You
Leen


"Mike H" wrote:

Hi.

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

Mike
"Leen" wrote:

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.
--
Thank You
Leen

Expanding Data into multiple columns
 

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



Leen wrote:

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.
--
Thank You
Leen

--

Dave Peterson

Expanding Data into multiple columns
 

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


"Teethless mama" wrote:

Format column A as General


"Leen" wrote:

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.


--
Thank You
Leen


"Mike H" wrote:

Hi.

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

Mike
"Leen" wrote:

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.
--
Thank You
Leen