Long column of dates:how to delete just the year?

[michaelx]

I have a LONG colum of dates: 00/00/0000. I want to sort by just the month
and day..How do I "highlight" (?) just the year to be able to delete the year
then sort by day and month?

 

[JoAnn Paules]

Have you tried a find and replace?

 

[grammatim]

I have a LONG colum of dates: 00/00/0000.  I want to sort by just the month
and day..How do I "highlight" (?) just the year to be able to delete the year
then sort by day and month?

Simply sorting the column will get it sorted by day and month (since
they come first).

 

[Janet A. Thompson]

You might also try to select a columnar years by holding down the Alt key
while selecting. Depending on spacing this may not be best method and the
find and replace would be best.

 

[macropod]

Hi michaelx,

If you *really* want to delete the years, use Find/Replace with wildcards 'on'.

For the 'Find' expression:
([0-9]{1,2}/[0-9]{1,2})(/[0-9]{2,4})
and, for the 'Replace' expression:
\1

This will handle dates in the form of 0/0/00, 0/0/0000, 0/00/0000, 00/00/0000, etc.

 

[Graham Mayor]

If you want to sort the dates by day and month ignoring the years (but
leaving them in situ), you can do this by using the replace function with
wildcards to replace
([0-9]{2}/[0-9]{2}/)([0-9]{4})
with
\1&&\2
Run the sort function with the date option, then replace && with nothing.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>