sorting alpha numerics

S

Sproove

I have a list of documents that I need to sort by title. Example

AFI10-229
AFI10-245
AFI10-1101

After I sort, the list looks like this

AFI10-1101
AFI10-229
AFI10-245

How do I make it take the entire alphanumeric into account?
 
A

Aladin Akyurek

Let A2:A4 house the sample to sort.

In B2 enter & copy down:

=--REPLACE(A2,1,SEARCH("-",A2),"")

Sort A2:B4, with column A in ascending order and column B in descendin
order.
 
M

Myrna Larson

If what you mean is that the 1101 entry should be at the bottom, that won't
happen unless you pad the numeric portion of all entries with leading zeroes,
i.e.

AFI10-0229
AFI10-0245
AFI10-1101
 
Top