SORT() number in sequence with letter at the end

[mart_mrexcel]

I have source data where some of the same numbers have 1 letter at the end (always at the right). My question is, is there a way to sort it using a sort function where it will be in sequence even there is a letter (see below sample expected output)

Source Data​	Expected output​
204668​	204056​
204056​	204056a​
208223​	204668​
208379​	204668a​
208714​	208223​
208855​	208379​
204056a​	208714​
204668a​	208855​

 

[Peter_SSs]

Like this?

24 03 06.xlsm
	A	B
1	Source Data	Expected output
2	204668	204056
3	204056	204056a
4	208223	204668
5	208379	204668a
6	208714	208223
7	208855	208379
8	204056a	208714
9	204668a	208855
Sort

Cell Formulas
Range	Formula
B2:B9	B2	=SORTBY(A2:A9,LEFT(A2:A9,6))
Dynamic array formulas.