I need an excel formula to delete words that are in CAPITALS and ignore sentence case and lowercase.
I have managed to extract the UPPERCASE words using this formula:
But need to DELETE them.
The dog is WET
The Dog IS wet
THE Dog is WET
The dog is
The Dog wet
Any help would be greatly appreciated!!