Link to home
Create AccountLog in
Avatar of Alex Campbell
Alex CampbellFlag 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:
  • 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.
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Alex Campbell


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.