Sorting Question

S

sekhalil

How do you sort a list with numbers and Number-letter combinations
For instance, I would like to sort a list with numbers like this- 1, 2, 3, 3A, 4, 4A, 5, 6, 6
I can't seem to get the letter number combinations to sort in order with the numbers. Is there a way??
 
C

CLR

One way is to use a helper column with this formula

=IF(ISTEXT(A1),A1,A1&".")

Then sort normally and "Copy and Paste Special Values" to get rid of the
formulas and "Find and Replace" the periods if you want.

Vaya con dios,
Chuck, CABGx3
 
D

Dave Peterson

When I did the Edit|Replace, my numbers (1., 2.) got converted back to numbers!

Another formula:

=a1&""
and drag down.

This'll convert the numbers to text and leave the text alone.

And sort by that helper column.
 
Top