Featured Formulas

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

Featured Functions

TEXT Function

The TEXT function in Excel is a tool for formatting numbers, dates, and times as text. The purpose of the TEXT function is to convert a number to text using a specified format code. TEXT is most often used to control the formatting of a number embedded into a text string. However, TEXT is also a...Read more

Recent Articles

Your program is great and I continue to learn from it every day. You provide such a great service. My job efficiency has really taken off and I am more productive leaving time spent to analyze data.
Kurt
I would just like to say, that being a high level excel user, your site has been a godsend for me. I have taken to using Exceljet rather than excel help as I can more readily find what I am looking for with clearer guidance on how to implement.
Michelle
Thank you very much for your fantastic Excel guide that I discovered this morning. It inspires me to continue discovering Excel (which I have started to detest as much as I love it :-)
Bart

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