Exceljet

Featured Formulas

Split text string at specific character

In this example, the goal is to split a text string at the underscore("_") character with a formula. Notice the location of the underscore is different in each row. This means the formula needs to locate the position of the underscore character first...Read more

Names

Split full name into parts

Lookup

Find closest match

More Formulas

Featured Functions

Dynamic array

UNIQUE Function

The Excel UNIQUE function extracts a list of unique values from a range or array. The result is a dynamic array of unique values. If this array is the final result (i.e. not handed off to another function), array values will "spill" onto the worksheet into a...Read more

Text

TRIM Function

Logical

IFS Function

More Functions

Recent Articles

Formulas

Why some Excel functions won't spill

Ever wonder why some Excel functions stubbornly refuse to spill results into multiple cells, even when you give them a range of data? For example, if you give some functions like EOMONTH or...Read more

Complex Numbers in Excel

Formulas

Shortcuts

Functions

User Testimonials

Thank you for making such a user-friendly and informative website!

Casey

Your pages offer clear writing and simple explanations that I'm sure are immensely helpful to many. Thanks for making the internet a better place.

David

Just wanted to say thank you for this extraordinary resource and awesome examples; the examples you guys give here are some of the clearest and best on the internet. Exceljet and Stackoverflow are really my go-to for any kind of learning.

Weiqi

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

Learn Excel with clear examples and bite-sized videos.

Featured Formulas

Split text string at specific character

Split full name into parts

Find closest match

Featured Videos

How to create a mixed reference

How to add slicers to a pivot table

How to make a nested IF formula easier to read

Two-way summary with dynamic arrays

Featured Functions

UNIQUE Function

TRIM Function

IFS Function

Recent Articles

Why some Excel functions won't spill

Formula challenge - list names by teams

Floating Point Errors in Excel

Regular Expressions in Excel

Complex Numbers in Excel

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Get Training

We offer free resources and paid training.

Learn Excel with clear examples and bite-sized videos.

Featured Formulas

Featured Videos

Featured Functions

Recent Articles

Topics By Category

User Testimonials

Newsletter Sign-up

Conquer Excel

Get Training

We offer free resources and paid training.