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

MODERATOR NOTE: Please reply privately

Join to automatically receive all group messages.