Special Sorting Need Advice...

  • Thread starter Thread starter KCPDX
  • Start date Start date
K

KCPDX

I need help sorting a row a certain alphanumeric way.
Currently i have this..
2b
1
1a
3b
2
1b
2a
3
3a

and i need it to look like this

1a
1b
2a
2b
3a
3b
1
2
3

Is there a special sort to do this, any help would be great!

Thanks
Kris
 
I would suggest that you use some helper cells to extract the number and
alpha separately and sort on these.

Is it always 1 digit 1 alpha, or is it more complex?
 
Its just as simple as that, there might a situation where the a
numeric aphla might go beyond 10

7a
8a
9a
10a
11a
12a
ect
 
To get the number only into a helper cell you can use:

=LEFT(A1,LEN(A1)-1)*1

and to get the alpha character you can use:

=RIGHT(A1,1)

in another column. Then copy these down as required. When sorting,
include these helper columns within the range to be sorted, click on
Data | Sort, and sort on the number first followed by the alpha
character.

Hope this helps.

Pete
 
Back
Top