Sort cells with numbers and text but not alphabetically

[Resortlife]

I am trying to sort the cells both numerically and letters but not alphabetically. I need to keep the numerical values sorted from low to high but the sizes in the correct order of XS, S, M, L, XL, XXL. I have tried doing a custom list and applying this to the cells but it won't change them. Can anyone help?
Thanks
001/223 590-L
001/223 590-M
001/223 590-S
001/223 590-XL
001/223 590-XS
001/223 590-XXL
001/223 999-L
001/223 999-M
001/223 999-S
001/223 999-XL
001/223 999-XS
001/223 999-XXL

[AliGW]

Welcome to the forum.

You'd need a helper column 'rank' the sizing letters.

There are instructions at the top of the page explaining how to attach your sample workbook.

[KOKOSEK]

	B	C	D
2	001/223 590-L		001/223 400-XS
3	001/223 590-M		001/223 400-M
4	001/223 590-S		001/223 400-L
5	001/223 590-XL		001/223 400-XL
6	001/223 590-XS		001/223 590-XS
7	001/223 590-XXL		001/223 590-S
8	001/223 999-L		001/223 590-M
9	001/223 999-M		001/223 590-L
10	001/223 999-S		001/223 590-XL
11	001/223 999-XL		001/223 590-XXL
12	001/223 999-XS		001/223 999-XS
13	001/223 999-XXL		001/223 999-S
14	001/223 400-XL		001/223 999-M
15	001/223 400-XS		001/223 999-L
16	001/223 400-L		001/223 999-XL
17	001/223 400-M		001/223 999-XXL

	B	C	D
2	001/223 590-L		=LET( MyList,$B$2:$B$20, letters2numbers,{"XS",1;"S",2;"M",3;"L",4;"XL",5;"XXL",6}, numbers2letters,{1,"XS";2,"S";3,"M";4,"L";5,"XL";6,"XXL"}, convertTo, SORT(LEFT(MyList,12)&VLOOKUP(MID(MyList,13,3),letters2numbers,2,0)), IFERROR(LEFT(convertTo,12)&VLOOKUP(MID(convertTo,13,3)*1,numbers2letters,2,0),"") )
3	001/223 590-M		001/223 400-M
4	001/223 590-S		001/223 400-L

[AliGW]

Bravo! Great use of the LET function. Me likey!!!

[KOKOSEK]

Thanks AliGW. I've blushed myself

[AliGW]

The last thing I got this excited about was PowerQuery. LET, for me, is the find of the year so far. I've just started playing with it.

[Resortlife]

Thanks for this guys I will see if I can do it