Sorting by ###, ###, ###A, ###B

[bluegurl337]

Ok, so I have a big problem. We have a massive spreadsheet with many many columns, but the primary sort we want is our job#s. The problem is that our job numbers are out of sort and I cant seem to figure out a way to put them back in order.

They should be:
1500
1501
1501A
1501B
1502
1503
1504
1504A
1505

What Im getting is
1500
1501
1502
1503
1504
1505
1501A
1501B
1504A

Anyone have a solution to fix them without having to go back and manually reorder more than 2000 job#s?

[Fluff13]

If the numbers are always four digits you could use a helper column with

Please Login or Register  to view this content.

copied down and the sort on the helper column

[CK76]

In addition to what Fluff recommended. I'd suggest using Data->Sort to use multi-level sort.

First level is smallest to largest on helper column. 2nd level is on original column, A to Z.

[MarvinP]

Hi Bluegurl,

You need to convert those numbers in your list to text and then sort the column.

Read: https://www.extendoffice.com/documen...r-to-text.html using the Text() function.
Look at my Helper Column on the attached and the formula. Sort by either column and see the difference.
Number to Text then Sort.xlsx

[CK76]

@MarvinP
Ah, that's cleaner way to sort.