Featured Formulas

Validate strong password

In this example, the goal is to check for "strong" passwords. What makes a password strong depends on the rules it must follow. In this case, a strong password must meet the following six conditions:

  1. At least 8 and not more than 15 characters long
  2. Contains at least one
  3. ...Read more

Featured Functions

SEARCH Function

The SEARCH function returns the position (as a number) of one text string inside another. In the most basic case, you can use SEARCH to locate the position of a substring in a text string. You can also use SEARCH to check if a cell contains specific text....Read more

Recent Articles

I absolutely LUV your explanations and examples! You have saved me a lot of time and frustration. Thank you, thank you, thank you.
Katalin
I just wanted to share how great EXCELJET is! You do such a great job covering a lot of topics and explaining them simply. I appreciate all the effort that goes into it.
Ryan
Just wanted to drop in and say thank you! You've helped me solve SO MANY PROBLEMS over the years. Today, I learned the difference between Excel's FIND and SEARCH function and was able to write a formula that must have saved me hours of manual work.
Amanda

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages