Tuesday, March 21, 2017

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