JewishGen Discussion Group #JewishGen Excel Database Sorting Problem #general


Jim Bennett <bennett@...>
 

A colleague compiled a 4000-name database of deaths, and in the Date of
Death column he entered the dates in the European way, as follows:
22.5.1839. I have not been able to sort in chronological order.
Is there a simple way to separate the three components, arrange them into
three separate columns, and then sort? Or, at the very least, just sort
according to the final four digits--by year.

Jim Bennett
Haifa

MODERATOR NOTE: Please reply privately

Join main@groups.jewishgen.org to automatically receive all group messages.