View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Billns Billns is offline
external usenet poster
 
Posts: 84
Default How to sort names in alphabetical ascending order?

On 4/18/2010 12:10 AM, Eric wrote:
There is a table from cell M2 to W200, which contains names and empty cell.
I would like to retrieve the names and sort them in in alphabetical
ascending order under Z column.
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric


The brute force approach would be to copy and paste each column M to W
to column Z individually, then sort alphabetically in column Z. If you
don't need to retain the names in the table you could cut and paste instead.

Bill