Split Text into a Clean List
Tools and Utilities • Text and List Utilities
Frequently Asked Questions
How does auto-detect choose the delimiter when splitting text into a clean list?
Auto-detect selects a delimiter based on the input content, prioritizing newlines first, then commas, then semicolons. The detected delimiter hint shows what the calculator recognizes before you run the split.
When should I use a custom delimiter to split text into a list?
Use Custom delimiter when your text is separated by a special character or string that is not newline, comma, or semicolon. Examples include |, --, or other unique separators.
What does the Trim option do when splitting text into list items?
Trim removes extra whitespace from the beginning and end of each item after splitting. This prevents spaces from creating visually different items that should be treated as the same text.
Why should I enable Remove blanks when converting text into a clean list?
Remove blanks removes empty results created by consecutive delimiters or trailing separators. This produces a cleaner list and a more accurate item count.
What is the purpose of collapsing multiple spaces in list cleaning?
Collapse multiple spaces replaces repeated spaces inside an item with a single space. It improves consistency when the input text contains uneven spacing.