Constructing Reality...

Excel How-To

How to Split Text into Columns in Excel

Split full names, addresses, or CSV-style cells into separate columns with the Text to Columns wizard or TEXTSPLIT.

Do it with AI instead

Step by step

1
Select the column
Click the column header containing the combined text.
2
Open Text to Columns
Go to Data ▸ Text to Columns.
3
Choose a delimiter
Pick Delimited, then choose comma, space, or a custom character.
4
Finish
Set the destination cell and click Finish.

=TEXTSPLIT(A2, ",")

FAQ

How do I split without overwriting the next column?

In the wizard's last step, set Destination to an empty area first.

Related guides

How to Combine Text in Excel (CONCAT / TEXTJOIN)How to Convert Text to Numbers in Excel

Keep exploring

Functions

CONCAT TEXTJOIN LEFT MID