yogi_Sort Entries In Column A (that begin with Numerics and then an alpha) By Numerics Then Letter

Google Spreadsheet   Post  #2136

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-21-2017

question by argjunks:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/CEF_B1kgw6Y;context-place=forum/docs
Sort alphanumeric strings by number, then letter

Hello,

I have a series of cells:

1A

1B

57F

42J

42

1

1C

and I want to sort them by number (either one or two digits), then the following letter. If there is no letter after the number, I want it to come first, like such:

1

1A

1B

1C

42

42J

57F

I have this so far:

=SORT(SPLIT( UPPER(UNIQUE(FILTER(A22:A63,A22:A63<>""))) , "ABCDEFGHIJKLMNOPQRSTUVWXYZ " ), 1, TRUE)

but it is only spitting out the number in the cell, so it is giving me:

1

1

1

1

42

42

57

Please help! Thanks in advance