Help out a company with bad security practices to validate their passwords with Excel!

You are given the following requirements:

– At least six characters long

– No spaces

– At least one number

– At least one special character

Drop your solution in the comments below 🙂

Our solution:

=IF(AND(LEN(F4)>=6;NOT(ISNUMBER(SEARCH(” “;F4)));
COUNT(FIND({0;1;2;3;4;5;6;7;8;9};F4))>0;
COUNT(FIND($K$4:$K$16;F4))>0);”Valid”;”Invalid”)