Formula for Sorting numbers and letters in single cell

[Rift_tide]

I have one cell lets say cell A1 that contains a string of IDs separated by a comma, some IDs contain letters. ie: 1, 8s, 40h, 12, 6k, etc...
I'm looking for a way to get cell A2 to read: 1, 6k, 8s, 12, 40h ... It'd also be great to remove duplicates.
I've been wracking my brain the last couple days trying to come up with a formula that would do this but have come up empty.
The letter is always at the end and is preceded by either one or two numbers.
Any help would be appreciated.

 

[Peter_SSs]

Is this what you are after?

23 12 03.xlsm
	A	B
1	1, 40x, 40h, 8s, 40h, 12, 6k, 40h, 1	1, 6k, 8s, 12, 40h, 40x
Sort in cell

Cell Formulas
Range	Formula
B1	B1	=LET(b,TEXTSPLIT(A1,", "),n,1+ISNUMBER(-MID(b,2,1)),TEXTJOIN(", ",,UNIQUE(SORTBY(b,TEXT(LEFT(b,n),"00")&MID(b,1+n,99)),1)))

 

[Rift_tide]

Is this what you are after?

23 12 03.xlsm
	A	B
1	1, 40x, 40h, 8s, 40h, 12, 6k, 40h, 1	1, 6k, 8s, 12, 40h, 40x
Sort in cell

Cell Formulas
Range	Formula
B1	B1	=LET(b,TEXTSPLIT(A1,", "),n,1+ISNUMBER(-MID(b,2,1)),TEXTJOIN(", ",,UNIQUE(SORTBY(b,TEXT(LEFT(b,n),"00")&MID(b,1+n,99)),1)))

That's exactly it. Thank you!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.