May 05 2023 11:29 AM
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?
May 05 2023 11:58 AM
See for example Sorting as if EBCDIC as on a mainframe