Thread: how can I sort a column numerically with both words and numbers i.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cam890 Cam890 is offline
external usenet poster
  
Posts: 2
Default 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.
Reply With QuoteReply With Quote