Hi - Dave here.
Last week, I shared an
example of how the new TEXTSPLIT function can simplify older complicated formulas.
This week, I want to introduce two other new functions that will help simplify text processing formulas: TEXTBEFORE and TEXTAFTER.
In the worksheet below, here are the "before" formulas:
LEFT(B5,FIND("_",B5)-1) // left
RIGHT(B5,LEN(B5)-FIND("_",B5)) // right
And here are the "after" formulas:
=TEXTBEFORE(B5,"_") // left
=TEXTAFTER(B5,"_") // right
As you can see, TEXTBEFORE and TEXTAFTER are simple to use.
[
download the workbook and read the full explanation]
TEXTBEFORE and TEXTAFTER are only available in Excel 365, but the "before" formulas above will work fine in older versions. The article above explains both approaches, and the workbook includes both options. Download the workbook and have a look.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
