TEXTSPLIT in Excel
Key points
- Build the formula
- Pick the second
- Paste it
SPLIT Builder also shows the TEXTSPLIT formula for Excel (365).
Steps
- Build the formula
- Pick the second
- Paste it
Older Excel versions do not have TEXTSPLIT.
Use "Build a SPLIT Formula" (free)
Tools that go well with this
- Split Text into Columns by a Delimiter: Split text into columns by a delimiter.
- Build a LEFT, MID or RIGHT Formula: Build text extraction formulas.
- Build a TEXTJOIN Formula: Build a TEXTJOIN formula.