Forum Discussion
How to order numbers by whole number, not just first digit of number
I work in archaeology, and have a document to organize some artifacts we found during a recent assessment. The artifacts are labelled according to the initials of the technician who found them, and i...
It would be better to store the initials and the sequence number in separate columns, but with the current setup you can extract them into two helper columns:
The formula in B2 is =LEFT(A2,2) and that in C2 is =--MID(A2,3,10)
Fill down from B2:C2.
You can then sort the entire range on Initials, then on Sequence Number:
Result: