Everyday I have to update several lists.
They arrive to me on an excel spreadsheet in random order.
They are in one column with spaces mixed in throughout the list.

I want to be able to cut and paste those lists into my spreadsheet and
have them automatically re-order themselves in alphabetical order and
have the blank cells ignored.

I know about Excel's SORT function. I have been using it for years.
It will save me about 12 mins each morning if I can skip that step.
(Which would save me a workweek each year.)


I have gotten this far using an array:


=INDEX($A$1:$A$99,MATCH(SMALL(COUNTIF($A$1:$A$99," <"&$A$1:$A$99),ROW
(B1)),COUNTIF($A$1:$A$99,"<"&$A$1:$A$99),0))

This sorts the list in column A. The problem is the blank cells
appear at the top pf the list. I need the list to start in B1 and
the blank cells to be ignored.


I don't want to use VBA or a Macro to do it either.

Thanks,

Dan