Featured Formulas

Featured Functions

TRIM Function

The TRIM function strips extra spaces from text, leaving only a single space between words, and removing any leading or trailing space. For example:

=TRIM("   A stitch    in time.   ")  // returns "A stitch in time."

The TRIM function can...Read more

Recent Articles

Have used your site for years to get great Excel tips. I appreciate their clarity and coverage of syntax past the most basic structures. Unknown to me, I had a 'free' parenthesis in a very long nested IF statement and was having trouble tracking it down. I read through your 19 Tips for Nested IF Formulas and while I knew many of them, the tips on IFS statements, using the Alt-Enter for structuring the logic and F9 where really what I needed.
Hal
You are the best! Exceljet is my first stop to find quick specific answers to my excel questions and get my spreadsheets back up and running! Thank you!
Marisa
Thank you! I got it working. Your site and advice is fantastic!
Holly

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