Featured Formulas

Names

Split full name into parts

In this example, the goal is to split the names in column B into three separate parts (First, Middle, and Last) with a single formula. In cases where there is no middle name, the Middle column should be blank. In cases where there are two middle names, the Middle column should contain both names...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Logical

IFS Function

The IFs function evaluates multiple expressions and returns a result that corresponds to the first TRUE result. You can use the IFS function when you want a self-contained formula to test multiple conditions at the same time without nesting...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Thank you for helping me save countless hours and frustrations with a quick search and awesome, easy to read info.
Enrique
Just a quick note to say thank you for your valuable website. I am a casual user of Excel and appreciate being able to use the suggestions you offer to simplify my sheets. I have used a number of your examples to manipulate data for personal record keeping. THANK YOU!
Robin
I love your website! I use it all the time. In fact, I used it over the past few weeks to help me make a great workbook. keep up the great work, and thanks for all the help your site has given me.
Steve
More Testimonials

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