Hi
Place this formula in an un-used column:
For example:
Your "12/34/56789" numbers are in column A
beginning at row 2 and going to row 2000
Place this in an unused column in row 2:
=Right(A2,2)
Copy the formula down to row 2000
Now sort using the new column as the key.
Tom
[ This Message was edited by: TsTom on 2002-04-25 04:46 ]
Like this thread? Share it with others