Quick Answer & Formula
Excel
Sheets
Beginner
=TEXTSPLIT(A2, ", ") | Google Sheets: =SPLIT(A2, ",") In Excel 365, use =TEXTSPLIT(A2, ", "). In Google Sheets, use =SPLIT(A2, ", "). Both formulas automatically spill values horizontally across adjacent columns.
How to Split Delimited Text into Columns in Excel & Google Sheets
Transform raw comma-delimited or pipe-delimited text exports into clean tabular columns with real-time formulas.
1. Splitting Comma-Separated Values (CSV)
If A2 contains "Chicago, IL, 60601":
=TEXTSPLIT(A2, ", ")- Spills:
Chicago(Col B),IL(Col C),60601(Col D).
2. Splitting SKU / Part Numbers by Hyphen
If A2 contains "US-ELEC-4029-B":
=TEXTSPLIT(A2, "-")- Spills:
US|ELEC|4029|B.
?
Frequently Asked Questions
How do I split by multiple different characters at once?
Pass an array of delimiters in curly braces: =TEXTSPLIT(A2, {",", "-", "/", ";"}).