Sort text with number as prefix within a cell

Hello!

Let's say I want to generate a product name following the composition of raw materials.
AA, BB, CC, DD, EE and FF are the components.
50, 100, 8, 12, 1 and 2 are the quantities.

To get a name with the most present component at the begining, I would like to sort ascending the data inside cells S1 and S3.

The formula I founded (Classeur4.xlsx) works pretty well, but it's more complicated when I have a number below 10.

Do you think there is a workaround to do that?

Thanks!

Awesome HansDouwe !! That's absolutely perfect!!

Thanks kvsrinivasamurthy, but I think there is a glitch in your formula because it's no sorted :/

Thanks all!

Look at this screenshot.
On the left, it's your formula, and on the right the one from HansDouwe.

With yours, it's not sorted.
It's

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Or did I missed something?