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