I have a list of text names that are unordered alphabetically, the list also contains blanks, I need a formula that will sort the list alphabetically and discard the blanks.

Many thanks in advance

J