| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding sequence of data | Excel Discussion (Misc queries) | |||
| Expanding amount of data in a formula | Excel Discussion (Misc queries) | |||
| ncaa template - expanding formulas for multiple picks | Excel Discussion (Misc queries) | |||
| sorting data and expanding the selection | Excel Discussion (Misc queries) | |||
| Expanding data | Excel Worksheet Functions | |||
Linear Mode
