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

