Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to split one column into multiple columns in Excel and Google Sheets
Excel & Google Sheets
=TEXTSPLIT(A2, "-")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the cell where you want the first part of the split data to appear.
- 2Enter the appropriate formula based on your spreadsheet application (Excel or Google Sheets).
- 3Drag the fill handle down to apply the formula to other cells.
Tips
- Ensure the delimiter used in the formula matches the delimiter in your data.
- Check for any leading or trailing spaces in your data that might affect the split.
- In Excel, TEXTSPLIT is available in Office 365 and later versions.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What if my data uses a different delimiter?
Change the delimiter in the formula to match the one used in your data.
Can I split data into more than two columns?
Yes, both functions will automatically distribute the split data across multiple columns.
What happens if there are fewer delimiters than expected columns?
The remaining columns will be filled with empty values.