Featured Formulas

Dynamic array

Sort by substring

We have a list of 12 codes in Column B. Each code consists of a prefix (two letters), a color (variable), and a 4-digit number, all separated by hyphens (e.g., AX-Red-6387). The goal is to sort this list based on the color substring so that all codes with the same color are grouped together in...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

REGEXTEST Function

The REGEXTEST function provides a way to test for specific text defined by a "regex" pattern. The result from REGEXTEST is TRUE or FALSE. You can think of REGEXTEST as a major upgrade to simpler functions like FIND and SEARCH, which can be used to...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I love.. love...love the weekly exercises that you send. Your website is my #1 go to for help with Excel. I also keep your web address on the whiteboard in my training room and share it with all of my students (Adult Educational Training). I have used several of your examples with my training exercises.
Karen
Thank you for helping me save countless hours and frustrations with a quick search and awesome, easy to read info. ExcelJet is always my first go-to resource when trying to untangle something in Excel. I can't thank you both enough <3 <3 <3
Alexis
Kudos to you for your very helpful site. I have gotten into the habit of Googling to solve problems I am having with Excel, and your site invariably is the one that provides the clearest explanations.
Jeff
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