How to sort a list in Word/Excel if standard tools don't help?

Question

excel

How to get absabsabs from the list aaaaabbbbbbbsssss...?

Answer 1

shushpanio , but not. It is easily done through formulas + sorting:
Yes, it is not visible there, but the cell x42 from the formula is to the left of the number, and x41, respectively, to the left and above.
But I still prefer vba because it's faster

Answer 2

Not with state funds.
Only with VBA.