Tools Vault selection / Pro+ collection
Use Tool Finder if you do not know the ribbon group. Confirm the final location in your installed version.
Tool guide
Split a combined column
One cell contains multiple fields that you need to analyze separately.
What it solves
Use this when…
One cell contains multiple fields that you need to analyze separately.
Expected result: Separate fields ready for sorting, matching or analysis.
How to use
Follow these steps
Try the action on a copy of your workbook first.
1
Inspect a sample
Identify a consistent delimiter or pattern.
2
Select the source
Choose the column and preserve a copy of the original.
3
Preview and run
Confirm destination columns and check rows with missing or extra separators.
Before you finish
Check the output
Confirm the result against the source and keep your own judgement in the loop.
Unexpected input format
Check headings, selected ranges and text/number formats before running. Work on a copy for consequential changes.
Ready to explore?
Make Excel work better for you.
Start with the current 10-day trial, or speak to us about what your team needs.