Avatar of Alex Campbell
Alex Campbell
Flag for United States of America asked on

Need Excel 2016 Custom Function To Evaluate Each Character of a String for Passwords

I have a list of possible passwords that need to be evaluated if they meet the characters needed for passwords:
For example:
@Re@S70p1492
  • Has symbols
  • Has uppercase
  • Has lowercase
  • Has numbers
If easier, it could also be done that the custom function would return a value for a character in the string.
  • If a character is a symbol, the value would be 1
  • Uppercase, 10
  • Lowercase, 100
  • Numbers, 1000
  • The sum for a 4 character password would 1111.
Microsoft Excel

Avatar of undefined
Last Comment
Alex Campbell

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Patrick Matthews

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Alex Campbell

ASKER
Looks great. I especially like the RegExFind function. I tried to print the article and code from the ExEx link, but wasn't able to.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck