Featured Formulas

Clean and reformat telephone numbers

In this example, the goal is to clean up telephone numbers with inconsistent formatting and then reformat the numbers in the same way. In practice, this means we need to start by removing the extra non-numeric characters, including spaces, dashes, periods, and parentheses. Once these...Read more

Featured Functions

Recent Articles

Have you any idea how awesome you are?!?!?! I will be forever grateful for your blog, fantastic work, congratulations. Now I know exactly where to search for help when I need it...
Marcel
I get tonnes and tonnes of value from the occasional technical tip I pick up from your website. It is an amazing reference! Your website over the years has been incredibly valuable to me...your weekly emails such as the one below is the only regular blog from someone I sometimes read, every single other one from whoever else just gets the bin.
Dan
I just wanted to say thanks for your awesome Excel resource. I am constantly googling for how to do random tasks in Excel and Exceljet is consistently the best resource. I impress people at work with my amazing Excel skills, but mostly I just know how to find what I need at ExcelJet!!
Laura

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