Resources > Formula Help

How Do I Split Text Into Columns in Excel?

Last Updated: June 2026

Quick Answer

Use Text to Columns to split data by commas, spaces, tabs, or other delimiters. In newer Excel versions, you can also use TEXTSPLIT.

Method 1: Text to Columns

1. Select the column with text.
2. Go to Data > Text to Columns.
3. Choose Delimited.
4. Select the delimiter, such as comma or space.
5. Click Finish.

Method 2: TEXTSPLIT

=TEXTSPLIT(A2,",")

This splits the text in A2 wherever a comma appears.

Examples

=TEXTSPLIT(A2," ")

This splits first and last names separated by a space.

Need Help Cleaning Text Data?

If your spreadsheet has names, addresses, codes, or imported text that needs cleanup, I can help.

Book Excel Help