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,...
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
