tricky sorting question

RobR,

I suggest a helper column, with a formula like =RIGHT(A1,4)
Bring the formula down as far as needed, and sort on that column.

Beege




"RobR" <nospam@nospam.com> wrote in message
news:OlHIPIJHGHA.1100@TK2MSFTNGP10.phx.gbl...
>I need to sort all records by the last 4 digits in a particular column.
> ie, my data looks like
>
> alskjflkja0023
> lkahsflkjf0021
> mnslfkjas0019
>
> I need to order all records by the last 4 digits. Any ideas on
> how to go about doing that? All entries are 17 characters
> long so it would be the right most 4 digits of the 17 character
> string. Thanks!
>
>

Brilliant, worked perfectly. Thanks!

"Beege" <bwgilmanhah@comcast.net> wrote in message
news:43cee600_1@newsfeed.slurp.net...
> RobR,
>
> I suggest a helper column, with a formula like =RIGHT(A1,4)
> Bring the formula down as far as needed, and sort on that column.
>
> Beege
>
>
>
>
> "RobR" <nospam@nospam.com> wrote in message
> news:OlHIPIJHGHA.1100@TK2MSFTNGP10.phx.gbl...
>>I need to sort all records by the last 4 digits in a particular column.
>> ie, my data looks like
>>
>> alskjflkja0023
>> lkahsflkjf0021
>> mnslfkjas0019
>>
>> I need to order all records by the last 4 digits. Any ideas on
>> how to go about doing that? All entries are 17 characters
>> long so it would be the right most 4 digits of the 17 character
>> string. Thanks!
>>
>>
>
>