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.