Hi community,
I have long list of data as example below and i want to extract only Upper case letter and it is Assets. But i try to use the formula tool and it does not work. May i know how to extract only specific upper case wording?
Input
ASSETS
Assets
ASSets
Liabilities
Expected output
ASSETS.
Thank you