Does anyone know if there is a way to make Numbers sort mixed alpha-numeric data like the OS X Finder does file names? For example the Finder puts 2a before 11a, because 2 is less than 11, counting the entire digit string as a unit. This is sometimes called a "natural" sort. Sorting in numbers puts 11a before 2a, because 1 is less than 2, taking only one character at a time.
iMac Intel/2C2D, eMac G4/700 10.5, 10.4, 10.3, 9.2,
Mac OS X (10.5)
This thread has been closed by the system or the community team.
You may vote for any posts you find helpful, or search the Community for additional answers.
Can Numbers Do a "Natural" Sort?
Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.