Sorting data by last to digits

I have a worksheet that I need to sort by terminal digits (last 2 digits).

The data is in column A in the format:

'0004135296

Notice the ' at the beginning.

I need to sort this data by the 96 at the end.

Thanks.

On Wed, 23 Feb 2005 11:07:58 -0600, "Brian" <[email protected]>
wrote:

>I have a worksheet that I need to sort by terminal digits (last 2 digits).
>
>The data is in column A in the format:
>
>'0004135296
>
>Notice the ' at the beginning.
>
>I need to sort this data by the 96 at the end.
>
>Thanks.
>

Since your data is in text format, start a new column to the right of
your data and enter =RIGHT(A1,2) with A1 being your first entry in
your table. Copy it to the bottom row of your table and sort on the
new column.

Don S

Thanks a million!



"Don S" <[email protected]> wrote in message
news:[email protected]...
> On Wed, 23 Feb 2005 11:07:58 -0600, "Brian" <[email protected]>
> wrote:
>
>>I have a worksheet that I need to sort by terminal digits (last 2 digits).
>>
>>The data is in column A in the format:
>>
>>'0004135296
>>
>>Notice the ' at the beginning.
>>
>>I need to sort this data by the 96 at the end.
>>
>>Thanks.
>>
>
> Since your data is in text format, start a new column to the right of
> your data and enter =RIGHT(A1,2) with A1 being your first entry in
> your table. Copy it to the bottom row of your table and sort on the
> new column.
>
> Don S