AnsweredAssumed Answered

Sorting Order is backwards

Question asked by sbconsult on Mar 3, 2018
Latest reply on Mar 7, 2018 by beverly

HI... I'm attempting to sort numbers with letters... as shown.  I created two calculations to separate the numbers and letters into their own fields but when I sort them I get the numbers with no letters showing first in the column.  (FYI, the maximum being used is one or two digits with only one letter sometimes following the digits)

 

My goal is the following result... (numbers with letters come first, and then just numbers.)

9A

9B

9B

9

9

10A

10A

10C

10

10

10

 

Thanks in advance!!

Outcomes