Sort Alphanumeric Data

[naresh_ank]

Hello Team,

My self requried to sort the Alphanumeric Data Ex: A10,A2,A7,C1,C9,C5,A3,B5,B1,B9,A1,C8

Please suggest how sort this kind of Data in the Excel

Thanks

 

[sandy666]

change to
A10,A02,A07,C01,C09,C05,A03,B05,B01,B09,A01,C08
then sort

 

[jasonb75]

Is there always 1 letter on the left, of can the number of letters (and their positions) vary?

There are many ways to answer your question based on the limited information that you have provided, but there will only be one solution.

 

[Rahul1987]

Hello Team,

My self requried to sort the Alphanumeric Data Ex: A10,A2,A7,C1,C9,C5,A3,B5,B1,B9,A1,C8

Please suggest how sort this kind of Data in the Excel

Thanks

How about?

I know it's very spinning formula , however this will help you...sorry for the late post , I just saw it now

Book1
	A	B	C	D	E
1	A10,A2,A7,C1,C9,C5,A3,B5,B1,B9,A1,C8
2				Unique Count	10
3		Sr	Data	Answer
4		1	A10	A2
5		2	A2	A3
6		3	A7	A7
7		4	C1	B1
8		5	C9	B5
9		6	C5	B9
10		7	A3	C1
11		8	B5	C5
12		9	B1	C8
13		10	B9	C9
14		11	A10
15		12	C8
Sheet1

Cell Formulas
Range	Formula
E2	E2	=COUNT(MATCH(ROW(Data)-ROW($C$3),MMULT((Data<>"")*(Data>TRANSPOSE(Data)),1^ROW(Data)),0))
B5:B15	B5	=B4+1
D4:D15	D4	=IF(ROWS(D$4:D4)>$E$2,"",INDEX(Data,INDEX(MODE.MULT(IFNA(MATCH(ROW(Data)-ROW($C$3),MMULT((Data<>"")*(Data>TRANSPOSE(Data)),1^ROW(Data)),{0,0}),"")),ROWS(D$4:D4))))
Press CTRL+SHIFT+ENTER to enter array formulas.

Named Ranges
Name	Refers To	Cells
Data	=Sheet1!$C$4:$C$15	E2, D4:D15

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4:C15	Cell Value	duplicates	text	NO