TEXTSPLIT with multiple delimiters - cool trick!

Hi - Dave here. Happy Friday! Did you know that TEXTSPLIT can handle multiple delimiters? This sounds super boring and technical, but it is actually quite useful! The video below explains with two examples. In the first example, the text contains inconsistent delimiters, and we configure TEXTSPLIT step-by-step to handle each variation. In the second example, the source text contains unwanted labels, and we use TEXTSPLIT to remove the labels and split the text simultaneously. You can use this trick to wow colleagues at work :) [How to use TEXTSPLIT with multiple delimiters]( [[Click to watch the video - 4 minutes](] This video is part of our course on Dynamic Array Formulas, which covers new advanced formulas in Excel. If you already own this course, you'll find this new video in the Text Functions section. Excel has changed a lot in the last few years and Dynamic Arrays are the biggest change to Excel's formula engine ever. They are a huge upgrade to what you can do with formulas in Excel. Note: TEXTSPLIT is only available in Excel 365. Excel formulas We maintain a list of over 500 working formulas [here](. If you need more structure, we also offer [video training](. Have a great weekend! Dave [View this email in a browser]( [Exceljet Logo]( Exceljet P.O. Box 4804 Salt Lake City, UT 84110 Copyright © 2024 Exceljet, All rights reserved. You received this email because you are subscribed to our newsletter. To unsubscribe, click the link below. [Unsubscribe](