Sort The list of items by Alpha / numeric in their proper sequential order

**DON_BLACK** · 07-11-2013, 03:06 PM

I am having trouble sorting the following item. If I start our with P1,it will go Form Rev.1-Template.xlsxto P11 instead of P2,P3, and vice versa.

**shg** · 07-11-2013, 03:20 PM

You need to pad the numbers out to constant length, e.g., change P1 to P01, for sorting. Or you could use some formulas:

Please Login or Register  to view this content.

J3 and copy down, =LEFT(A3)

K3 and copy down, =--MID(A3, 2, 3)

**martindwilson** · 07-11-2013, 03:25 PM

or use since you only have one leading alpha
=LEFT(A3)&TEXT(RIGHT(A3,LEN(A3)-1),"000")

**DON_BLACK** · 07-11-2013, 03:42 PM

@MartinDwilson it worked. I remove two of the zero's and set a custom filter A001,Z999. This sorts them in their sequential order.

Re: Sort The list of items by Alpha / numeric in their proper sequential order