Sort alphanumerically (updated)

**newdoverman** · 08-10-2013, 06:55 PM

This is going to sound a "little off the wall" but it works with your example.

Copy the data into Word. Select the data and convert to table. Sort the table on column 6. When doing the sort, select column 6 to be NUMBER and sort order to be DESCENDING. That's right DESCENDING. The order will be correct. Convert the table back to text and copy and paste back into Excel. When converting back to text, select OTHER and enter a SPACE in the box for the "other" character.

**TJCloutier** · 08-10-2013, 06:59 PM

Can you show me what you did? I want to know what its SUPPOSED to look like, formula wise after. To be honest I don't understand why I can't just input a simple formula or have an option to have this happen

Originally Posted by newdoverman

This is going to sound a "little off the wall" but it works with your example.

Copy the data into Word. Select the data and convert to table. Sort the table on column 6. When doing the sort, select column 6 to be NUMBER and sort order to be DESCENDING. That's right DESCENDING. The order will be correct. Convert the table back to text and copy and paste back into Excel. When converting back to text, select OTHER and enter a SPACE in the box for the "other" character.