Featured Formulas

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

Featured Functions

Recent Articles

I do really appreciate the work you have done. It is a cut above everything else out there.
Doug
I've recently begun to learn to really exploit some of the real power of Excel and I find your Exceljet site is the easiest of all I've seen to navigate and understand. Your explanations are clear and concise with very good samples. And I love the way you have the "Excel Formulas" section of your site set up. It is so easy to look up the formula you need information on. And furthermore, if unsure of what strategy to use to accomplish your goal all your formula pages have links to other similar things to try. Its been a great resource for me. Thank you so much!
Scott
I am an IT Trainer, based in London and working internationally worldwide, mostly Pharma, Banking and Law Firms. I subscribed to your newsletter and regularly visit your website. I am completely blown away by your mails and explanations. They are by far the best one can find on the web. I look forward to your weekly letter. I refer to your website every single Excel training and to every customer I have!
Avi

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