Split text into columns
Break "red, green, blue" into separate cells with one formula.
The formula
Excel · Excel 365 only
=TEXTSPLIT(A2, ", ")Google Sheets
=SPLIT(A2, ", ", FALSE)How it works
A2The text to split.
", "The delimiter. In SPLIT, FALSE makes it treat ", " as one delimiter instead of splitting at each character.
Example
| A: Tags | B | C | D |
|---|---|---|---|
| red, green, blue | red | green | blue |
| small, large | small | large |
Tips
- The results spill into the cells to the right, so keep them empty.
- In older Excel use Data > Text to Columns instead.