Sort numbers by the first integer

S

skiman123321

I have a column of numbers that I sort based on the first integer. Fo
example,
I want
2
4
77
555
777
11111

to sort as

11111
2
4
555
77
777

Is there a way to do that? Thanks
 
B

britwiz

skiman123321 said:
I have a column of numbers that I sort based on the first integer. For
example,
I want
2
4
77
555
777
11111

to sort as

11111
2
4
555
77
777

Is there a way to do that? Thanks.
Click to expand...

Hi skiman123321

Use a helper column with =LEFT(A1,1) copied down as far as necessary.

Then sort the two columns based on the helper column.

Regards

Steve
 
M

Michael

Try using a helper column that has just the first digit: =left(a2,1), and
sort on that column. You can always delete or hide the column after sorting.
 
Top