Hello,
I'm looking for a way to scan a column to see if the text in it contains 3 of 4 required things - upper case, lower case, number and/or symbol. I've uploaded an example, as well as a formula I found online for locating upper case and lower case, but they both show False even though they shouldn't.
Do you know of a way to search to see if at least three of the four are included in the text?
try
=IF(EXACT(B2,UPPER(B2)),"Upper Case Only",IF(EXACT(B2,LOWER(B2)),"Lower Case only",IF(ISERROR(SUMPRODUCT(SEARCH(MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1),"abcdefghijklmnopqrstuvwxyz"))),"Meets","Upper and Lower Case only")))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
What are valid special characters?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks