VBA course sale ends today + interesting formula

Hi - Dave here. Just a friendly reminder that the special offer for Victor Chan's "Launch Excel Macros and VBA School" ends today. If you've been thinking about improving your Excel skills with VBA, now is a good time. His course includes 10 hours of video lessons, practical projects, some nice bonuses, and personalized support from Victor himself. With the current sale, you can save 60% off the full price of $497. [Click here for all the details]( Interesting formula One of the best things about the new formula engine in Excel is how it can make short work of previously difficult problems. For example, several times a year someone asks me how to sum a set of numbers in the same cell, as seen below. What used to be a hard problem in Excel is now quite easy with the TEXTSPLIT function: [How to sum formulas in a single cell?]( [Click here for the workbook and explanation]( Older versions of Excel do not provide TEXTSPLIT, but in the Windows version of Excel, you can use a clever workaround based on the FILTERXML function. See the link above for details. More formulas We maintain a list of over 500 working formulas [here](. If you need more structure, we also offer [video training](. I hope you have a nice week and weekend! Dave PS - Next Monday is Memorial Day here in the U.S., so no email Friday. [View email in browser]( [Exceljet Logo]( Exceljet P.O. Box 4804 Salt Lake City, UT 84110 Copyright © 2023 Exceljet, All rights reserved. You received this email because you are subscribed to our newsletter. To unsubscribe, click the link below. [Unsubscribe](