Featured Formulas

Text

Split comma-separated values to multiple columns

In this example, the goal is to split comma-separated values (CSV) in column B into multiple columns, as seen in the worksheet shown. Each text string in column B contains 5 fields separated by commas, so we expect to get 5 columns of data as a result. The header row in column D is manually...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Logical

IFERROR Function

The IFERROR function returns a custom result when a formula returns an error and a normal result when a formula calculates without an error. The typical syntax for the IFERROR function looks like this:

=IFERROR(formula,custom)...Read more
More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Just one big thank you for the amazingly easy videos you send regarding Excel formulae etc. Your explanations are easy to understand and to copy in Excel while you are busy explaining.
Hans
Exceljet is my go-to place when I need a formula that I can't remember how to code. You folks have a terrific website, you examples are easy to follow, you explain what the formula is doing, and show options or alternatives. I usually use your alternatives to teach myself new ways to exploit Excel. Great job and thank you.
Steve
I have been using Excel for years and love it. Just want to tell you your site is great, and thank you for all your hard work!
Maury
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