Turn one messy cell into clean columns
If you receive data like "name,phone,email" all packed into a single cell, Text to Columns makes it easy to split each piece into its own dedicated column.
Check for duplicates while you are cleaning up
After splitting data into proper columns, it is often worth also scanning for duplicate rows β between splitting and deduplicating, most common spreadsheet cleanup jobs are covered without writing a single formula.
Frequently Asked Questions
What if multiple delimiters are mixed together?
On the delimiter screen you can check several options at once β comma, tab, space, and more β so mixed delimiters can be handled in a single pass.
What happens to the original column after splitting?
The split data fills in starting from the original column position and expands to the right, so it is a good idea to make sure there are empty columns available to the right beforehand.