Create a list of uppercase data from a range excluding blanks and errors

Yes, there maybe lower cases mixed in. My example does not show it. I should have made one mixed letters. See corrected example below. Thanks

AA - DD
#N/A
BB - 23 - Ea - FF
#N/A
#N/A - 12 - GG
CC


Results:

AA
BB
CC
DD
FF
GG