Sort Problem

T

Trish

Hi All,

In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file
10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B
order?

Thanks for any replies.

Trish
 
D

Dave Peterson

I'd add a couple of helper columns. Put the number portion in one column and
the text in the other. Then sort the range by these two helper columns.

Another option could be to enter the data in a consistent format:

1A --> 01A
3B --> 03B

Use as many digits as you need in the worst case.
 
Top