sorting combined alpha character with numbers

B

B. Murray

How can I sort alpha and numbers. (i.e. 6-A, 1-A, 2-A, 1-B,11-A
I want it to sort 1-A, 1-B, 2-A,6-A, 11-A
Thanks
 
F

Frank Kabel

Hi
you may use two helper columns for this and sorting with these helper
columns. e.g. use the following two formulas
=--TRIM(LEFT(A1,FIND("-",A1)-1))
and
=TRIM(MID(A1,FIND("-",A1)+1,255))
and copy both formulas for all rows.
 
Top