How to Use LET with TEXTBEFORE and TEXTAFTER to Sort Numeric vs Text

Description:
Ever imported a list in Excel where some rows have the name before the slash and others have the number before the slash? Sorting that mess by hand is painful, and a single TEXTBEFORE or TEXTAFTER formula won't cut it because the sides aren't consistent. In this tutorial, you'll build a LET formula that inspects each row and routes the text and the number into their own clean columns, no matter which side they started on.

Covered inside:
→ Setting up the Text and Number header row in B1 and C1
→ Writing the first LET formula in B2 using TEXTBEFORE and TEXTAFTER to name both pieces
→ Using ISNUMBER with VALUE to detect which side of the slash holds the number
→ Flipping the return logic in C2 so the numeric side lands in the number column
→ Selecting B2 and C2 together and double-clicking the fill handle to copy down
→ Verifying all eight rows split correctly into names and numbers

Which part did you lean on more, defining b as the before-slash piece or a as the after-slash piece? Drop your version of the formula in the comments if you tweaked the ISNUMBER check.

#Excel #ExcelTutorial #LETFunction #TEXTBEFORE #TEXTAFTER #ExcelFormulas #DataCleaning #ISNUMBER #SpreadsheetTips #ExcelTips2026 #SplitData #OfficeProductivity