Split DATE cell into three new cells?

[Xx Licher xX]

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...

 

[Luke M]

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

 

[Bob Phillips]

Do a Data>Text To Columns, with a delimiter of /.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)