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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I sort a column numerically with both words and numbers i.
You could split the text to columns... if all of the cells are like your
example below. Higlight the column On the Data menu, click Text to Columns. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns. If you need to put the cels back together you can use the concatenate function "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. |
#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. |
Reply |
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 |