sorting alpha numerics

[Guest]

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?

 

[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.

 

[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