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