Sorting table by Alphanumeric Values in a column - A-101,B-101,B-1101

[vikrampnz]

Hello

I have a table with 250 Unit numbers and their respective parameters. The unit numbers look like this A-101, A-203, A-1001, B-103, B-405, B-1105, C-105, C-605, C-1004, L-15, U-12, O-8 etc.

When I try to sort the table by Unit numbers, (First based on the alphabet and then the number), it places A-101, A-1001 above A-203 and similarly for all the alphabets.

Is there a way I can get it to sort in following fashion:

A-101
A-203
A-1001
B-103
B-405
B-1105
C-105
C-605
C-1004
L-15
O-8
U-12

Would appreciate any help in this. Thanks in advance

 

[Fluff]

You could use a helper column & sort on that,using

Fluff.xlsm
	K	L
1
2	A-101	A-0101
3	A-203	A-0203
4	A-1001	A-1001
5	B-103	B-0103
6	B-405	B-0405
7	B-1105	B-1105
8	C-105	C-0105
9	C-605	C-0605
10	C-1004	C-1004
11	L-15	L-0015
12	O-8	O-0008
13	U-12	U-0012
Data

Cell Formulas
Range	Formula
L2:L13	L2	=LEFT(K2,2)&TEXT(MID(K2,3,10)+0,"0000")

 

[vikrampnz]

That worked perfectly !! Thanks for your prompt help Fluff !!

 

[Fluff]

You're welcome & thanks for the feedback.