About Delimiters
Key points
- Enter the delimiter
- See the formula
- Check it
In SPLIT Builder you can split at a comma, a space, a hyphen and more.
Steps
- Enter the delimiter
- See the formula
- Check it
Text without the delimiter is not split.
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.