Sorting Street Numbers
 

oops type !

=LEFT(A2,COUNT(1*MID(A2,ROW($1:$9),1)))

On Nov 18, 9:58*pm, muddan madhu wrote:
Col A has values

in cell B2 put this formula ( once u enter the formula not just
enter , use ctrl + shift + enter )

=LEFT(A2,COUNT(1*MID(A1,ROW($1:$9),1)))

in Col B you will get only values extracted from Col A now use sorting
u will get the desired result.

On Nov 18, 9:39*pm, BASR52 wrote:

I'm using Excel 2007. *How would I sort the following:

1111th
131st
1st
223rd
2nd
3rd
65th

to get:

1st
2nd
3rd
65th
131st
223rd
1111th