Forum Discussion
Sorting a mixed text/number Column by number on a Mac
I'm on a Mac and trying to sort a column by numbers but it's not sorting how you would actually count. For instance, instead of sorting 1 through 20 as you'd normally count, it is sorting 1, 10, 11,...
Riny_van_Eekelen Hi Riny: I have tried your solution on some test data and IT WORKS. I am very appreciative of your help. thank you very much. Paul
What worked for me. and my data.
Add a space between number and alpha using Flash Fill. 1045A becomes 1045 A
Highlight the column and select data, then "Text to columns. This creates a second column with the alpha data. Now sort: first on the numeric column and then on the alpha column. Thanks to all for helping me get through this puzzeler.
Add a space between number and alpha using Flash Fill. 1045A becomes 1045 A
Highlight the column and select data, then "Text to columns. This creates a second column with the alpha data. Now sort: first on the numeric column and then on the alpha column. Thanks to all for helping me get through this puzzeler.