| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I sort a column numerically with both words and numbers i.
I have one long column. In each cell/row I have: name number place. With a
space between each. E.g. Tom 123.7 London I want to sort the column in descending order numerically. When I clicked the sort button it just does it alphabetically. Please please help! Many Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to sort "words" that are numbers and letters | Excel Discussion (Misc queries) | |||
| how can i sort on a perticular column for odd and even numbers | Excel Worksheet Functions | |||
| auto sum column containing words and numbers | Excel Worksheet Functions | |||
| how do i sort a column numerically going from 01-01 to 225-99 | Excel Worksheet Functions | |||
| looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions | |||
Threaded Mode
