View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to sort names in alphabetical ascending order?

Do you have any suggestions on what kind of functions work with text
characters?
Thanks in advance for any suggestions
Eric

"Ms-Exl-Learner" wrote:

Large and Small functions only work with the Numbers and it doesn't work with
Text Characters.

--------------------
(Ms-Exl-Learner)
--------------------


"Eric" wrote:

N.B. how can I sort them using formula, such as large or small function
Thanks in advance for any suggestions
Eric

"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