| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
spliting a cell into more cells
is it possible to split up a cell, if i have a date '11.12.09' and i want the
day, the month, and the year to be in seperate cells is it possible if so how? and does it work if i want to do this for a whole collum of dates? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
spliting a cell into more cells
datatext to columns
-- Don Guillett Microsoft MVP Excel SalesAid Software "RowzeRiot" wrote in message ... is it possible to split up a cell, if i have a date '11.12.09' and i want the day, the month, and the year to be in seperate cells is it possible if so how? and does it work if i want to do this for a whole collum of dates? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
spliting a cell into more cells
Hi,
With your date in A1 put these in b1, c1 & d1 then select all 3 and drag down =DAY(A1) =MONTH(A1) =YEAR(A1) Mike "RowzeRiot" wrote: is it possible to split up a cell, if i have a date '11.12.09' and i want the day, the month, and the year to be in seperate cells is it possible if so how? and does it work if i want to do this for a whole collum of dates? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
spliting a cell into more cells
If it is there as text, use Data/ Text to columns, and use the full stop as
delimiter. If the 11.12.09 is a real date, use =DAY(A1) =MONTH(A1) and =YEAR(A1) and copy down. -- David Biddulph "RowzeRiot" wrote in message ... is it possible to split up a cell, if i have a date '11.12.09' and i want the day, the month, and the year to be in seperate cells is it possible if so how? and does it work if i want to do this for a whole collum of dates? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spliting a cell | Excel Discussion (Misc queries) | |||
| Spliting a cell into two parts | Excel Discussion (Misc queries) | |||
| Excel Spliting Cells | Excel Discussion (Misc queries) | |||
| help with spliting data cells | New Users to Excel | |||
| Spliting the contents of a cell to other cells | Excel Worksheet Functions | |||
Linear Mode
