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
|