How to Split Cells in Excel for the Web

How-to basics · Updated November 18, 2026

To split text in a cell into separate columns in Excel for the web, select the cells, choose Data > Text to Columns, pick the delimiter that separates the values, and apply the split. Before you start, make sure the columns to the right are empty. This separates text such as a full name or a comma-separated list; it does not divide one worksheet cell into smaller grid cells.

What You’ll Need

  • An Excel workbook open in Excel for the web, with permission to edit it.
  • The text you want to split, ideally in one column with one record per row.
  • A clear separator between the parts, such as a comma, space, semicolon, tab, or another consistent character.
  • Empty columns to the right of the source column, or a safe copy of the source data. Splitting can place results over existing cells.

Step-by-Step

  1. Check how the source text is arranged. Each cell you select should contain one record to divide. For example, a column might contain “Mina Patel, Sales” and “Leo Chen, Support.” In this example, a comma separates the name from the department. If the values do not use a consistent separator, review the data before splitting; the tool cannot reliably infer where one part ends and another begins.
  2. Protect the original data. If the information matters, duplicate the source column first: select its column letter, copy it, select an empty column, and paste. You can also duplicate the worksheet or save a separate copy of the workbook. This gives you a way to recover if the split produces an unexpected result. Confirm that the cells immediately to the right of the intended output area are blank.
  3. Select the source cells. Click the first cell in the column, then drag down to the last row you want to split. You can select the whole column by clicking its letter, but a range is safer when the sheet contains headers, notes, or unrelated data farther down. Include the header only if you want it split too. If the first row is a heading such as “Name, Department,” select the data rows beneath it instead.
  4. Open the split command. On the ribbon, choose Data > Text to Columns. If the browser window is narrow, some ribbon commands may be tucked into a menu or the ribbon may need expanding. Confirm that you are in Excel for the web and that the workbook is in edit mode; a read-only view will not let you apply changes.
  5. Choose the delimiter. Select the option for delimited text, then specify the character that marks each boundary. Choose comma for “Mina Patel, Sales,” a space for “Mina Patel” if you intend to split at every space, or a semicolon if the values use semicolons. If the interface offers a custom delimiter, enter the exact character used in your data. Check the preview or the displayed split before continuing.
  6. Check the number and order of output columns. A delimiter can appear more than once in a cell, and every occurrence may create another part. For example, splitting “North, East, West” by comma produces three pieces, not two. If the preview shows too many columns, choose a delimiter that marks only the boundary you actually need, or use the formula option described below for more control.
  7. Apply the split and inspect the results. Finish or apply the Text to Columns action using the button shown in the pane or wizard. Check the first few rows and several rows farther down. Make sure text has landed in the intended columns, that no existing values were replaced, and that names, codes, or dates have not been separated unexpectedly. If the result is wrong, use Ctrl+Z on Windows or Command+Z on Mac immediately, then adjust the selection or delimiter and try again.
  8. Keep or remove the original column deliberately. The split creates separate values; it does not mean you should automatically delete the source. Keep it until you have checked the output and any formulas or reports that depend on it. Once you are sure the new columns are correct, you can retain the original for reference or remove it if the worksheet no longer needs it.

For a repeatable split, or when you want the original text to remain untouched, use a formula in an empty cell instead. With the text “Mina Patel, Sales” in A2 and a comma followed by a space between the two parts, enter =TEXTSPLIT(A2,", ") in B2. The result spills into B2 and C2 as “Mina Patel” and “Sales.” TEXTSPLIT is available in Microsoft 365, including Excel for the web. Leave the neighboring output cells empty, or Excel may show a spill error. To process more rows, copy the formula down; each row’s result needs enough clear columns to the right.

Common Mistakes

  • Expecting to split the worksheet grid cell itself. Excel’s Text to Columns divides the cell’s contents into neighboring cells. It does not turn one cell into two smaller grid cells. If you mean a merged cell, use Home > Merge & Center to unmerge it; this restores the original cells in the grid, but it does not divide the text inside the merged value.
  • Choosing a delimiter that also appears inside a value. Splitting a street address on every space, for example, can scatter its number, street name, and apartment details across several columns. Consider whether the separator is unique and consistent before choosing it.
  • Forgetting that repeated separators create empty pieces. Two commas together, or a comma followed by extra spaces, may result in a blank column or an extra part. Clean up inconsistent source text first where possible, and inspect examples with missing information before applying the split to the entire range.
  • Overwriting neighboring data. If there is content to the right of the selected source, a multi-column split may replace it or prevent the operation. Insert blank columns or move the output to a safe area first. Do not assume that Excel will automatically make room.
  • Selecting the header by accident. A header may be split differently from the records, especially if it does not use the same delimiter. Select data rows only when you want the heading to stay intact, then add suitable headings to the new columns.
  • Assuming the split understands meaning. The command follows separators; it does not know that “Patel” is part of a surname or that a comma belongs inside a quoted address field. Review the source pattern and check the results instead of treating a successful command as proof that every row is correct.

Tips

  • Use a copy when experimenting. A duplicate column lets you compare the original and split values row by row. This is especially useful for customer lists, imported reports, or records that would be difficult to recreate.
  • Test a small sample first. Split a few representative rows, including the longest values and any rows with missing parts. If the output is sensible, apply the same approach to the full range.
  • Match the delimiter exactly. A comma and a comma followed by a space are different separators in a formula. In Text to Columns, check whether spaces after punctuation are being kept with the next value, and clean them if needed.
  • Use formulas when the source may change. Text to Columns is a direct edit to the selected data. A TEXTSPLIT formula keeps the source cell intact and recalculates when the source changes. It is useful for a maintained list, but the formula’s spilled results need clear cells and may not be suitable for every downstream workflow.
  • Make the output headings clear. After separating a column, label the new columns, such as “First name” and “Last name” or “Name” and “Department.” Clear labels make the sheet easier to filter, share, and use in later calculations.
  • Check special values after splitting. Product codes, postal codes, and identifiers can look like numbers. Verify that Excel has not changed their formatting or removed leading zeros. If those characters matter, format the destination cells as text before entering or splitting values where possible.

Troubleshooting

  • Text to Columns is missing or unavailable: Make sure the workbook is open in edit mode, not read-only, and that you have selected cells containing text. Expand the ribbon or check the Data tab for the command. If your organization’s Excel web setup does not show the feature, try opening the workbook in the Excel desktop app, where Data > Text to Columns is available.
  • The split creates too many columns: The chosen delimiter occurs more often than expected. Undo the change, choose a more specific separator, or use a formula with the exact delimiter. For instance, splitting on comma-space is more precise than splitting on a comma when commas are followed by spaces consistently.
  • Parts appear in the wrong columns or have extra spaces: Check the preview and the source text for inconsistent spacing, punctuation, or repeated delimiters. A formula split can also preserve spaces if they are not included in the delimiter. Adjust the delimiter or clean the text, then check a sample again.
  • The formula shows a spill error: Clear the cells where the formula needs to return its results, including cells to the right. Also check for merged cells in the output area. TEXTSPLIT returns multiple results across cells, so it cannot spill into occupied or merged cells.
  • Some rows do not split correctly: Those records may use a different separator or may be missing one. Compare the source rows with a successful row, correct the inconsistent entries, and run the split on a suitable range. If the separator is not consistent, a single delimiter-based operation may not be enough.
  • You changed the wrong data: Use Ctrl+Z on Windows or Command+Z on Mac right away. If undo is no longer available, restore the backup or reopen a previous version if your file storage provides one. Avoid saving further changes until you know which recovery option is safe.

Frequently Asked Questions

Can I split one Excel cell into two actual cells?
Not by dividing the grid cell itself. Text to Columns separates its contents into neighboring cells. To restore a merged area to separate grid cells, unmerge it; the text remains in one cell.

Can I split text into rows instead of columns?
Text to Columns is intended to place separated parts in columns. If you need a vertical list, split into columns first and then copy the results and use Paste Special > Transpose if that command is available in your Excel web ribbon, or rearrange the values in a suitable layout.

Does Text to Columns change the original cell?
It uses the selected source data to create separate values in adjacent columns, so do not rely on it as a non-destructive transformation. Keep a copy of the source until you have verified the outcome.

Can I split names into first and last name?
Yes, if the names follow a consistent pattern and the chosen separator gives the result you want. Splitting on a space can create extra parts for middle names or multi-word surnames, so inspect the list first and consider keeping the full name as a reference.

Why does Excel leave a leading space after a comma?
If the delimiter is only a comma, the space after it is part of the next piece of text. Choose comma-space as the delimiter when that pattern is consistent, or clean the resulting values after the split.

Can I undo a split?
Usually, yes: use Ctrl+Z on Windows or Command+Z on Mac immediately after applying it. If you have made other edits since then, restoring a backup or an earlier file version may be safer.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.