Search for Upper Case
This works perfectly, Thanks!
"Ron Coderre" wrote:
with
A1: (text.....eg ibuPROfen)
This formula returns true if there are NO lower case letters:
B1: =EXACT(A1,LOWER(A1))
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Ken" wrote in message
...
How can I search in a cell for any letter in a word that may be upper
case?
For example I want to identify that a cell has a word such as ibuPROfen.
|