| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highest then alphabetical order By Names? | Excel Discussion (Misc queries) | |||
| How to sort worksheets in alphabetical order (descending or ascending)? | Excel Discussion (Misc queries) | |||
| sort last names by in alphabetical order | Excel Discussion (Misc queries) | |||
| Sort other than by alphabetical ascending/ descending | Excel Discussion (Misc queries) | |||
| Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) | |||
Threaded Mode
