Text to Columns in Excel: Split One Cell into Multiple Columns (2026)
Text to Columns in Excel — split one cell into multiple columns by comma, space or delimiter. Step-by-step with shortcut, Flash Fill alternative and fixes.
Text to Columns in Excel: Split One Cell into Multiple Columns (2026)
Got data like "Rahul Sharma, Delhi" stuck in one cell when you need it in two? Excel's Text to Columns splits one cell into multiple columns automatically — by comma, space, dash, or any separator.
This guide covers the classic Text to Columns wizard, fixed-width splitting, the faster Flash Fill alternative, and fixes for when it doesn't work as expected.
Table of Contents
- What Is Text to Columns?
- Split by Delimiter (Comma, Space, Dash)
- Split by Fixed Width
- The Faster Way: Flash Fill
- Splitting with Formulas (TEXTSPLIT)
- Common Problems & Fixes
- Frequently Asked Questions
- Conclusion
What Is Text to Columns?
A built-in Excel tool that takes text in one column and splits it into multiple columns using a delimiter (comma, space, tab) or fixed width (character positions). Perfect for cleaning imported data, CSV-style text, or combined fields like "Firstname Lastname".
Hindi: Ek cell ka data — jaise "Rahul Sharma, Delhi" — ko do ya teen columns mein todne ka Excel tool. Data → Text to Columns.
Split by Delimiter (Comma, Space, Dash)
- Select the column of cells to split
- Go to Data tab → Text to Columns
- Choose Delimited → Next
- Tick your separator — Comma, Space, Tab, or Other (type it, e.g.,
-) - Preview shows the split → Next → Finish
Excel splits each cell into as many columns as needed.
⚠️ It writes into the columns to the right — make sure they're empty, or data gets overwritten.
Split by Fixed Width
For data aligned at positions (no separators):
- Select cells → Data → Text to Columns
- Choose Fixed width → Next
- Click in the preview to place break lines where splits should happen
- Next → Finish
Useful for codes like EMP001-DELHI-2026 with consistent structure.
The Faster Way: Flash Fill
For simple splits, Flash Fill needs no wizard:
- In the cell next to your data, type the part you want (e.g., the first name)
- Start typing the next one — Excel detects the pattern and greys-in suggestions
- Press Ctrl + E (or Enter) — the whole column fills instantly
Flash Fill handles names, emails, codes — any consistent pattern.
Splitting with Formulas (TEXTSPLIT)
Excel 365 has a dynamic formula:
```
=TEXTSPLIT(A1, ",")
```
- Splits A1 by commas into separate cells automatically
- Updates live if the source changes (Text to Columns is one-time)
=TEXTSPLIT(A1, ",", "-")splits by multiple delimiters
Common Problems & Fixes
- Data overwritten — columns to the right weren't empty; undo (Ctrl+Z) and insert blank columns first
- Split didn't happen — wrong delimiter selected; check "Other" and type your actual separator
- Leading zeros vanished (001 → 1) — in step 3, set that column's data format to Text
- Extra spaces after split — wrap the result in
=TRIM()or re-split with space handling - Dates mangled — set the column format to Date or Text in step 3
Frequently Asked Questions
How do I split one cell into multiple columns in Excel?
Select the cells → Data → Text to Columns → Delimited → choose your separator (comma/space) → Finish.
What is the shortcut for Text to Columns in Excel?
Alt + D, E opens the Text to Columns wizard. For pattern-based splits, Ctrl + E (Flash Fill) is even faster.
How do I split a cell by a specific character like a dash?
In Text to Columns → Delimited → tick "Other" and type -. Or use =TEXTSPLIT(A1,"-") in Excel 365.
How do I split names into first and last name in Excel?
Text to Columns with Space as the delimiter — or Flash Fill: type the first name in the next column and press Ctrl+E.
Why did my numbers lose leading zeros after splitting?
Excel converted the column to numbers. In step 3 of the wizard, select that column and set format to Text to preserve zeros.
Does Text to Columns work in Google Sheets?
Similar feature: Data → "Split text to columns" — pick the separator, Sheets splits automatically.
Conclusion
Text to Columns cleans messy combined data in seconds: Data → Text to Columns → pick your delimiter → Finish. For quick one-off splits, Flash Fill (Ctrl+E) is even faster — and TEXTSPLIT is the formula way for live data.
Video Tutorial:
- Freeze Panes in Excel — Lock Headers
- AutoSum — Total in One Click
- Remove Duplicates in Excel
TAGS: text to columns excel, text to columns in excel shortcut, split cell excel, split excel cell into multiple rows, split cell data in excel, text to columns in excel in hindi, convert text to columns excel, excel split text, techn trainer
What's Your Reaction?
