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

C

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.
 
Z

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort a table that contains both numbers and blank cells 1
Can I combine 4 columns of data into one column? 1
how do I sort a column mixed with odd and even numbers .. ? 1
How? Sort Custom Numbering Scheme 3
sorting numbers and numbers that contain text in excel 2
How can I sort the contents of one cell 7
Excel Excel: Sort a column with #.#.# number and keep other column 0
How can I sort a column of numbers generated by excel RAND funct? 5

Top