Need to extract UPPER CASE text from the right until it find lower case or number

Hi,

I need function to extract Upper Case Text from the right in cell Until it find lower case/number.

below are the example, Raw data and after remove lower and number.

[img=https://s31.postimg.org/67enmfnqf/Excel_Data.jpg]


Thanks