Main Forums > The Roundtable

excel sorting, mix of letters/numbers

<< < (3/3)

230RN:
Is this similar to dogmush's solution?

How would it work if you went to four numerical digits with the LSD (right-hand digit) being 0-9 with 0 corresponding to no separate little sub-room, and 1-9 corresponding to A-I little sub-rooms?  Am I understanding the problem correctly?

You can parse out that last letter if required later.
Divide room designation by 10, subtract the integer value from the full decimal value... if 0, no subrooms, if ,1 subroom A, if .2, B, etc.

MechAg94:

--- Quote from: K Frame on January 26, 2023, 11:24:46 AM ---OK, my first suggestion doesn't work.

Adding a new column for the letter designator and doing a custom two-tiered sort as suggest by Mech works.... sort of.

When I did it I got..

120A
120B
120C
120

221A
221B
221

I can't figure out how to get the numeric only room to list first, followed by the alpha numerics.

--- End quote ---
You might try using a symbol in the second column that has no letter.  I don't know if any symbols sort higher than "A".  There ought to be something that does. 

Navigation

[0] Message Index

[*] Previous page