How do you sort in Excel by 1, 1a, 1b, 1c, ...2, 2a?

M

MChapAcct

I want to sort a list of numbers in excel but I want 1A to be in between 1 &
2. Hos do I do that? I tried setting up a custom list, but no luck.
 
J

Jim Rech

To get the sort order you want all the items must be text. For example,
select A1:A3. Use Format, Cells and select Text as the number format.
Enter 1, 2, 1a in the cells and then click the Sort button on the Standard
toolbar. The order should sort to 1, 1a, 2.

--
Jim Rech
Excel MVP
|I want to sort a list of numbers in excel but I want 1A to be in between 1
&
| 2. Hos do I do that? I tried setting up a custom list, but no luck.
 
Top