Text Split Formula Generator
Split text into parts, extract substrings, or parse structured data like email addresses, full names, and CSV values from a single cell.
Syntax
=TEXTSPLIT(text, col_delimiter, [row_delimiter]) — Google Sheets: =SPLIT(text, delimiter)Try it — generate a Text Split / Extract formula
Examples
Extract first name
=LEFT(A2, FIND(" ", A2) - 1)Gets everything before the first space in a full name.
Extract domain from email
=RIGHT(A2, LEN(A2) - FIND("@", A2))Gets everything after the @ in an email address.
Tips
- ✓Google Sheets has SPLIT() which is simpler: =SPLIT(A1, " ") splits by spaces.
- ✓Excel 365 has TEXTSPLIT() which works similarly to Google Sheets' SPLIT.
- ✓For complex parsing, combine MID, FIND, and LEN functions.
Related Formulas
CONCATENATE / TEXTJOIN
Combine text from multiple cells into one. TEXTJOIN is the modern approach with ...
UNIQUE
UNIQUE returns a list of distinct values from a range, removing duplicates. It's...
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free