Splitting by Spaces
Key points
- Paste the text
- Enter a space
- Merge repeats
In Text to Columns you can split by putting a space in the delimiter field.
Steps
- Paste the text
- Enter a space
- Merge repeats
When spaces repeat, the setting that treats consecutive delimiters as one helps.
Use "Split Text into Columns by a Delimiter" (free)
Tools that go well with this
- Excel Table to Markdown, HTML, CSV and JSON: Convert a pasted table to Markdown, HTML, CSV or JSON.
- Remove Extra Spaces and Invisible Characters from Excel Text: Remove extra spaces and invisible characters.
- Merge, Split and Pick Columns from CSV: Merge CSV files, split by rows, or keep only chosen columns.