how can I sort a column numerically with both words and numbers i.

[Cam890]

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.

 

[zrider]

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

 

[Gord Dibben]

Try Data>Text 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