How to change “Sort” priorities?

Copper Contributor

If I plug into column A going down, something like “L, K, A, 1, F, 4, J, V, 5, W, 6” and sort A to Z, the result is “1, 4, 5, 6, A, F, J, K, L, V, W”. I want to change the priority to have letters first, and numbers second. The desired result would be, “A, F, J, K, L, V, W, 1, 4, 5, 6”. Any way to achieve this? 

1 Reply