Sort my mixed cards (values) as my formulas like

Hi,
I am working on some poker game variations. So far, I have managed to create some kind of data base where my staff enters the qualified combinations for the on going promotion and I am able to sort them from the best hand to the worst.
However, my staff keep entering some combinations in descending order and that order does not work with my formulas, therefore possibly winning hands are not recognized.

I think I have reached my Excel knowledge limit and I could not find any way to sort unorderly entered card combinations as in the picture below.

Any help is highly appreciated. Thanks in advance.

Screenshot 2019-05-26 19.17.49.png