Featured Formulas

Cell contains number

In this example, the goal is to test the passwords in column B to see if they contain a number. This is a surprisingly tricky problem because Excel doesn't have a function that will let you test for a number inside a text string directly. Note this is different from checking if a cell value...Read more

Featured Functions

Recent Articles

I'm a fairly advanced Excel user with a programming background and you are my go-to Excel reference. I really appreciate the work that you do and the high-quality, freely-available content you provide. I always plug your site when I help someone with an Excel-related issue at work.
Matt
I'm an aerospace engineer with a certain large corporation. I've spent the last 10 years overseas managing the structural reconstitution of damaged aircraft for a number of foreign ally Air Forces. I use your website to learn and refresh my memory on Excel functionality quite often. The way your data is organized, presented and explained is top-notch. I just wanted to let you know how much your site helps others and to say best wishes in all that you do. Your efforts are tremendously appreciated.
Z
Thanks for the resources you provide. I've bumped into it as an avid Excel user (not at your level though) and have immediately seen the value - wow.
Antonie

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