Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Street Numbers
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separate address numbers from street name | Excel Worksheet Functions | |||
Sorting Street Numbers | Excel Worksheet Functions | |||
Sorting street addresses | Excel Discussion (Misc queries) | |||
how do I convert cell 'Street,#' to '# Street' these are addresse | Excel Worksheet Functions | |||
How do I sort a column of street number/street name by the stree. | Excel Worksheet Functions |