How to sort text from highest to lowest digit or vice versa?

Question

excel

How to sort text by number from highest to lowest?

Answer 1

1. Add another column;
   
2. in the cell of the new column, write a formula that pulls a number out of the text;
   
3. sort with "Sort..."
   

Or do you need to sort the range? The same team. Do not forget to put the cursor on any cell in the range.