Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split DATE cell into three new cells?
Could anyone give some pointers as how I could do this???
I have a column "D" which holds MM/DD/YY (multiple records), and I need to split into three seperate colums- "E", "F", &"G", and delete the value in "D" or delete the column. Should I use FOR/NEXT??? Gracuious... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split DATE cell into three new cells?
Use DAY, MONTH, and YEAR functions.
E.g, Column E =DAY(D1) Column F =MONTH(D1) Column G =YEAR(D1) Then, select columns E:G, copy, right click, and do a paste special - values Then you can delete column D -- Best Regards, Luke M "Xx Licher xX" wrote: Could anyone give some pointers as how I could do this??? I have a column "D" which holds MM/DD/YY (multiple records), and I need to split into three seperate colums- "E", "F", &"G", and delete the value in "D" or delete the column. Should I use FOR/NEXT??? Gracuious... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split DATE cell into three new cells?
Do a DataText To Columns, with a delimiter of /.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Xx Licher xX" wrote in message ... Could anyone give some pointers as how I could do this??? I have a column "D" which holds MM/DD/YY (multiple records), and I need to split into three seperate colums- "E", "F", &"G", and delete the value in "D" or delete the column. Should I use FOR/NEXT??? Gracuious... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split date in cell into 2 separate cells | Excel Discussion (Misc queries) | |||
Split Date and Time Cell | Excel Discussion (Misc queries) | |||
Split the date & time in one cell to be 2 colums. | Excel Worksheet Functions | |||
how to split the cell which has the date formula (with day) | Excel Discussion (Misc queries) | |||
split combined Time Date cells | Excel Discussion (Misc queries) |