Forum Discussion
Sorting a mixed text/number Column by number on a Mac
AWitt77 You need to transform all entries in the column to real numbers. Simply setting the format is not sufficient. Select the column with the "numbers". On the Data ribbon select "Text to Columns".
Click "Next". until you reach step 3 of 3, Make sure "General" is selected. Press Finish. Now you will have real numbers that can be sorted as you expect then to be.
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.
Riny_van_Eekelenthank you so much for the help!!!
I have the following data in a column. 1, 1A, 2, 1B. 401B, 400. I would like them sorted as 1, 1A, 1B, 2, 400, 401B. How do I create this 'natural sort' ? Thanks
paulcechovicgmailcom See the attached workbook. Excel 365 or Excel for the web is required. Be sure to read the _Info worksheet.
