How do I sort multiple columns of of numerical and alphanumerical.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

slowmo - 18 Oct 2006 17:32 GMT

Example:

Column 1 Column 2 Column 3 Column 4 Column 5
1 9 09A1 0023 delete
3 11 11D4 1057 revise

I would like to sort first on column 1, then 2, then 3, then 4. When I
tried this, it messed up all the numbers in column 4. Help please

Reply to this Message

Bob Phillips - 18 Oct 2006 19:03 GMT

Select all 5 columns then sort by column 1.

Then sort by column 2 as first sort key, column 2 as second, and column 3 as
third.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Example:
>
[quoted text clipped - 4 lines]
> I would like to sort first on column 1, then 2, then 3, then 4. When I
> tried this, it messed up all the numbers in column 4. Help please

Reply to this Message