Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:

>Thanks to all, it seemed pretty simple and I did the solution you all

>suggested, showed the user how easy it was and then I got this question.

>

>Now he wants to sort by the social security number (SSN column) but only

>the last four. The menu driven way doesn't seem to have a substring

>option -- I was hoping 'advanced options' would uncover something but it

>didn't.

>

>So, how do you do a partial column sort?

>

>v/r

>

>

Sounds like you either need to have a temporary column containing only

the last four digits and sort on that, or use VBA.

Stuart