seeing the Excel thread reminded me...

[scud]

Excel 2003.

Current table.....
Column A; each row has a different date and time entry, but formatted the same (01/01/2010 00:00:00)

Desired table.....
I want to automatically split the date in Column A into three new columns: using the example above, this would mean;

Column B to have the day (01)
Column C to have the month (Jan)
Column D to have the year (2010)

There's loads of rows in the table, so I really don't want to have to do it manually

I don't need the time bit, they're all midnight anyway.

What's the best way of doing this?

Cheers

 

[C-J]

functions are your friend

=DAY(#Cellreference#)
=MONTH(#Cellreference#)
=YEAR(#Cellreference#)

Though these functions might not be available in your version of Excel... try them out and see what happens

 

[scud]

functions are your friend

=DAY(#Cellreference#)
=MONTH(#Cellreference#)
=YEAR(#Cellreference#)

Though these functions might not be available in your version of Excel... try them out and see what happens

Nearly!!!!

The month comes out as a number (1)... I need the month to be displayed as a 3 letter format (JAN).....

I know it's picky, but the owner wants it that way.

(currently it's all done manually!)


AHA!!! I've changed the cell to custom format MMM

Fantastic... thanks C-J