Hi!

Here's one way but it will only sort based on the first character of the
text entry.

Assume the text entries are in the range A1:A20. To extract those entries
sorted in ascending order, enter this formula as an array with the key combo
of CTRL,SHIFT,ENTER:

=INDEX(A$1:A$20,MATCH(SMALL(CODE(UPPER(LEFT(A$1:A$ 20,1))),ROW(1:1)),CODE(UPPER(LEFT(A$1:A$20,1))),0) )

Copy down as needed.

To sort in descending order, in the formula change SMALL to LARGE.

Biff

"malik641" wrote in
message ...

Anybody???


--
malik641
------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=381859