Excel has new TEXTBEFORE and TEXTAFTER functions. It doesn’t have a TEXTBETWEEN function. Let’s make one.
In the image below you can see we can combine TEXTBEFORE and TEXTAFTER to achieve a text between result.
We can use the LAMBDA function to make a TEXTBETWEEN custom function based on the formula with those two functions.
In the image below you can see the custom function in action.
Note I prefix all my custom function names with fn. This differentiates them from normal functions. Plus if you type fn in the Formula Bar you will also see a list of all the custom function in the file.
Below is the Edit Name dialog with the LAMBDA function.
I have included the LAMBDA formula below as well.
You can download the example Excel file at the button below.