MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sort


Posted by Matt on July 19, 2001 1:05 PM

I have a list of id numbers, some of which contain letters. I need to sort the column based on the number of digits in the ID. If I do a regular sort, Excel doesnt group the ID's with, for example 7 digits one or more being letters, with the 7 digit id's where all 7 digits are numbers. Anyh suggestions?


Posted by Barrie Davidson on July 19, 2001 1:26 PM

How about adding a column that identifies the length of the id, sort on that column, and secondary sort on the id itself? For example, if your id is in column A, add the following formula in your new column

=LEN(A1)

and copy down to the end.

Barrie