How to Split Text into Separate Columns in Excel

November 4, 2026

An export can arrive with several fields squeezed into one column. Excel’s Text to Columns wizard lets you separate those fields using a delimiter, such as a comma or tab.

This guide uses Excel for Microsoft 365 on Windows. The desktop wizard is the main workflow; browser controls differ.

Prepare a safe working copy

Save a copy of the workbook before converting the data. Select only the source column, and leave enough empty columns for the output. Microsoft warns that distributed data can overwrite adjacent cells.

For a simple practice example, enter A100,West,Open in A2 and A101,East,Closed in A3. Leave columns C, D, and E empty. The intended result is a code, region, and status in three separate columns.

Run Text to Columns

  1. Select the cells containing your combined text, such as A2:A3.
  2. Choose Data > Text to Columns.
  3. Select Delimited, then Next.
  4. Select the delimiter used by the source. For this example, select Comma and clear unrelated delimiter selections.
  5. Check the Data preview. Each field should appear in its intended column.
  6. Select Next and set the Destination. For the practice example, use $C$2.
  7. Select Finish.

Verify the output

The example should place A100, West, and Open in C2, D2, and E2. Row 3 should contain A101, East, and Closed. The original values remain in column A because you chose a separate destination.

For real data, inspect the first, middle, and last records, plus any unusual rows. Check codes, dates, empty fields, and text containing the delimiter before replacing the original column.

If the split looks wrong

Return to your working copy and revisit the preview. A space is not always a reliable separator: a department or person’s name may contain several spaces. Choose a delimiter that represents actual field boundaries in your source.

Optional: use a formula

In supported Excel versions, =TEXTSPLIT(A2,",") splits the example across columns in formula form. Put it in an empty area with room for the results. This offers an alternative when you want the split to refer to the source cell.

Sources

Topics:
Read next
November 21, 2026

How to Create and Configure a Shared Mailbox in Microsoft 365

Create a Microsoft 365 shared mailbox, grant the correct Full Access and Send As permissions, understand automapping and licensing, and verify that users can work from Outlook safely.
November 17, 2026

Microsoft 365 Business Basic vs Standard vs Premium vs E3 in Canada (2026): Which Plan Should You Buy?

A practical Canadian comparison of Microsoft 365 Business Basic, Standard, Premium, and E3, including verified November 2026 pricing, feature differences, user limits, hidden costs, and recommendations by business need.