Function extract the uppercase letters from strings of text

Hello,

I need to extract the uppercase words from strings of text.

Example: Assortment or Count Change Case
Needed result: ACCC


Thank you!!!

Hi Hellga,
try this UDF

Please Login or Register  to view this content.

formula on the sheet will look like this

Formula:

Please Login or Register  to view this content.

Thank you, Nilem!
It works fine!