| Home |
| Search |
| Today's Posts |
|
#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... |
| 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) | |||
Threaded Mode
