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.