L
laura3511
I'm trying to sort a list of part number like this:
10, 54, 94, 101, 1800, 200, 2000, 500
The only way I can find to sort them is:
10, 54, 94, 101, 200, 500, 1800, 2000
What I need is them sorted by the first digit and then the entire number:
10, 101, 1800, 200, 2000, 54, 500, 94
Is there any reasonable way to do this without manually creating another
column that has the first digit in it?
Any help would be greatly appreciated.
10, 54, 94, 101, 1800, 200, 2000, 500
The only way I can find to sort them is:
10, 54, 94, 101, 200, 500, 1800, 2000
What I need is them sorted by the first digit and then the entire number:
10, 101, 1800, 200, 2000, 54, 500, 94
Is there any reasonable way to do this without manually creating another
column that has the first digit in it?
Any help would be greatly appreciated.