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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.

--
HTH

Bob Phillips

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