I have string in cell A1: 4x100 5x98 4x108 4x98 4x114,3 5x120 3x112. My job is to sort this string to be as 3x112 4x98 4x100 4x108 4x114,3 5x98 5x120. These are car pdc's. First has to be 3 bolt, then 4 bolt and last 5 bolt. Then circle has to be from lowest to highest. I cannot find solution.