Hi
I need to search a column full of text, symbols and blanks. I need to
extract only cells which contain text in upper case and has 7 characters
(combination of 6 letters and a digit or just 7 letters). Content of those
cells need to by copy to another column in alphabetical order.

Thank you for your help

I need to add that needed text may have less characters then 7, however they
will be still in upper case.

Some of the text will also repeat, and only one entry is required.
Thank you again.