Hi - Dave here.
Happy Friday!
TEXTBEFORE and TEXTAFTER are perfect when you want to get text before or after a
specific delimiter. But what if you want to get text between
every delimiter?
In that case, Excel's TEXTSPLIT function is your friend.
The video below shows how to use TEXTSPLIT in three different ways: (1) to split email addresses into two parts, (2) to split comma-separated text into five columns, and (3) to split dimensions into three separate columns.
[
Click to watch the video (3 minutes)]
This video is part of our course on
Dynamic Array Formulas, which covers new functions in Excel. If you already own our Dynamic Array 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
