Hi - Dave here.
Last week, I shared an
example of a formula makeover with the new TEXTBEFORE and TEXTAFTER functions.
This week, I have a similar example with the TEXTSPLIT function. In the worksheet below, the goal is to split the text in column B into three separate dimensions. The original solution required 3 complex formulas:
L=LEFT(B5,FIND("x",B5)-1)+0
W=MID(B5,FIND("x",B5)+1,FIND("~",SUBSTITUTE(B5,"x","~",2))-FIND("x",B5)-1)+0
H=RIGHT(B5,LEN(B5)-FIND("~",SUBSTITUTE(B5,"x","~",2)))+0
The new formula in D5 is:
=TEXTSPLIT(B5,"x")+0
Yep, that's it. Just one simple formula :)
[
download the workbook and read the full explanation]
TEXTSPLIT only works in Excel 365, but the original formulas above work in older versions and are included. Read details and download the workbook in the article above.
New website!
We've been working for the past few months to update our website and the
new site is now live. Hope you like it!
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
