How to split one column into two?

[Robert Judge]

I have an EXCEL 97 worksheet that includes a column with birthdays in the
format 11/13/51, for instance, for November 13, 1951. I would like to split
that column into two columns. The first column would contain the month and
day (that is, 11/13) and the second column would contain the year (that is,
51). How can I do this?

 

[Max]

One way ..

Assuming the dates are in col A, A2 down,

Put:
In B2: =TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2)),"mm/dd")
In C2: =TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2)),"yy")

Select B2:C2, copy down

Col B will return the month/day,
col C will return the year

 

[Frank Kabel]

Hi
use if you want text values
=TEXT(A1,"MM/DD")
and
=TEXT(A1,"YY")

if you still want the date values but just displayed this way use
=A1
in both cells and apply a custom format ('Format -Cells') such as
MM/DD
and
YY