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...
=LEFT(E3,2)
=NUMBERVALUE(RIGHT(E3,LEN(E3)-2))
In the attached file i entered above formulas to split the labelling into two columns. This works as long as the initials of the technician are 2 digits. For example John Doe is JD or Mike Smith is MS. 3 digits would lead to a mistake in this example however.
After entering formulas in cells C3 and D3 and copying down i applied individual sort for range C3:E34. The data is sorted by column C (A to Z) and then by column D (ascending) as shown in the picture in the attached file.