| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I sort a column numerically with both words and numbers i.
Try DataText to Columns and break the data into 3 columns using space
delimited. Select all three columns and sort by number column. Gord Dibben MS Excel MVP On Wed, 16 Sep 2009 11:58:02 -0700, Cam890 wrote: 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
