Yes. In Excel for the web, select the cells you want to split, choose Data > Text to Columns, select the delimiter or fixed-width option that matches the data, review the preview, and finish. For a split that updates when the original text changes, use the TEXTSPLIT formula instead.
What splitting text into columns does
Splitting text takes several pieces stored in one cell and places them in separate neighboring columns. For example, a cell containing Jordan Lee,Portland,OR could become three cells: Jordan Lee, Portland, and OR. The original information is not being interpreted as a table automatically; you tell Excel where one piece ends and the next begins.
This is useful when importing a text file, pasting a list from an email, or receiving data in which fields have been joined together. Common separators include commas, tabs, semicolons, pipes, and spaces. Some data has no visible separator: a product code might always use its first four characters for a category and the remaining characters for an item number. That pattern calls for fixed-width splitting rather than a delimiter.
Excel for the web can perform a one-time split with Text to Columns. It can also split text with a formula, which is better when the source is likely to change or when you want to preserve the original column.
Use Text to Columns in Excel for the web
For a straightforward list with a consistent separator, the menu command is usually the quickest method. Make a copy of the source data first if you may need to keep it unchanged. Then follow these steps:
- Select the cells containing the combined text. If the data fills one column, select the relevant cells in that column rather than the entire worksheet.
- Choose Data > Text to Columns. If the command is not available in your current web interface, use the formula method below or open the workbook in the desktop app.
- Choose Delimited when a character such as a comma or tab separates the fields. Choose a fixed-width option when the fields always begin at the same character positions.
- For delimited data, select the separator that matches the source. Check the preview: each intended field should appear in its own column.
- Complete the wizard. Check the cells to the right before doing so, because the output may replace existing content in the destination area.
For example, if a selected cell contains 4581|Hardware|12.50, choose the pipe character (|) as the delimiter. The preview should show three fields. If it shows two, or splits a field that should stay together, stop and change the settings before applying the split.
Choose the right delimiter or field layout
The delimiter is the boundary between pieces of text. It must be consistent enough for Excel to identify the same boundary throughout the selected data. A comma-separated row such as 4821,Blue mug,3 is a natural fit for a comma delimiter. A tab-separated row copied from a report may need the tab option instead.
Spaces need extra care. Splitting Jordan Lee at every space produces Jordan and Lee, but splitting Jordan Lee, Portland at every space can create more columns than intended. If the real separator is a comma, choose comma and leave space unselected. When there are multiple spaces between fields, look for an option to treat consecutive delimiters as one, if the wizard offers it; otherwise, consider cleaning the data or using a formula designed for the actual pattern.
- Comma: Common in exported lists, though commas inside a description can make a simple split unsuitable.
- Tab: Often used when copying a table from another application.
- Semicolon or pipe: Useful when commas are part of the data itself.
- Fixed width: Appropriate for records with fields at predictable character positions, such as a legacy text report.
Before splitting a large range, inspect several rows, including the longest or messiest examples. A delimiter that works for the first few rows may occur inside a later description or name.
Split with TEXTSPLIT when the data should update
A formula is useful when you want to leave the source column intact, repeat the same split on new rows, or have the results recalculate after an edit. In Excel for the web, TEXTSPLIT returns the pieces into adjacent cells when there is room for the results to spill.
With the combined value Jordan Lee,Portland,OR in cell A2, enter this formula in B2:
=TEXTSPLIT(A2,",")
The result spills across B2:D2 as Jordan Lee, Portland, and OR. The comma inside the formula’s quotation marks is the delimiter. If A2 changes, the result updates automatically. The cells where the result needs to spill must be empty; otherwise Excel displays a spill error instead of overwriting those cells.
This formula splits at every comma. It does not understand all the rules of a quoted CSV file. For instance, a description such as mug, blue may include a comma that is part of the description rather than a field boundary. If the source uses quoted fields, choose a proper import or parsing workflow rather than assuming a simple delimiter formula will interpret those quotes correctly.
Protect your data and check the output
Text to Columns is a transformation, not merely a display option. If its output is placed over neighboring data, those values can be replaced. The safest approach is to work on a duplicate sheet or copy the source column to an area with enough empty columns. A formula avoids changing the original cells, though its spill range also needs to be clear.
Also check how Excel interprets values after splitting. A field containing 00127 may be treated as a number, which can remove its leading zeros. Dates and decimal values can also be interpreted according to regional settings. If a field is an identifier rather than a number, preserve it as text where possible; adding a number format later may not restore zeros that were already removed.
After the split, check a few records against the original, especially codes, dates, postal codes, and amounts. Confirm that the number of resulting columns is consistent and that no field has been cut at an internal comma or space. If the split is part of a recurring process, test it again with a newly added row before relying on it.
Common problems and practical fixes
- The result runs into existing values: Undo if possible, then clear the intended output area or use a new sheet before splitting again. Do not assume Excel will insert blank columns for you.
- One field is split into too many pieces: Check whether the chosen delimiter appears inside that field. A different delimiter, a more careful import, or a formula-based cleanup may be needed.
- Some rows split differently: The source may use inconsistent separators, such as a comma in one row and a semicolon in another, or contain extra spaces. Standardize the source or handle the exceptions separately.
- Leading zeros disappear: The output was likely interpreted as a number. Preserve identifier-like values as text, and check the result before using it in lookups or exports.
- The formula shows a spill error: Clear the cells to the right that the formula needs, and check for merged cells or other obstructions in the spill range.
- The command is missing: Try the browser version of Excel with the workbook open for editing, use
TEXTSPLIT, or open the file in desktop Excel. Available controls can vary with the interface and account.
Excel for the web compared with desktop Excel
The web version is convenient for quick edits and collaboration, and the steps for the Text to Columns command are broadly similar: select the data, open the Data tab, and choose Text to Columns. If the web interface does not show the command or its options do not cover the data, desktop Excel offers the fuller Convert Text to Columns Wizard. On Windows, the desktop path is Data > Text to Columns. On Mac, use the Data tab and its Text to Columns command; the layout of the wizard can differ by version.
Use the web version when the data has a simple, consistent separator and the output is easy to verify. Use desktop Excel or a dedicated import process when you need more control over unusual text qualifiers, fixed-width records, or data types. For repeated transformations, a formula or an import-and-clean workflow may be more dependable than re-running a one-time split manually.
Frequently Asked Questions
Can I split a column by a comma in Excel Online?
Select the cells and choose Data > Text to Columns, then choose comma as the delimiter and check the preview. For a formula result that updates, use TEXTSPLIT with the source cell and a comma delimiter.
Does Text to Columns delete the original text?
The command produces split values in the worksheet and may replace cells in the output area, depending on where the results are placed. Keep a copy of the source or split onto a new sheet if you need to preserve it. A TEXTSPLIT formula leaves the original cell unchanged.
How do I split a full name into first and last names?
If every name contains exactly one space, splitting at a space may work. It can give unexpected results for middle names, compound surnames, or extra spaces, so inspect the data and choose a method that reflects how the names are actually written.
Can I split text by more than one character?
The Text to Columns wizard can offer several delimiter choices, but the right settings depend on the pattern in the source. A simple TEXTSPLIT formula can split on a specified delimiter; for complicated records with quoted separators or inconsistent formatting, use a more suitable import or cleanup process.
Why is Text to Columns not showing in Excel for the web?
Check that the workbook is open in editing mode and that the Data tab is available. If the command still does not appear, use TEXTSPLIT for a straightforward delimiter-based split or open the workbook in desktop Excel.
Which method should you use?
For a one-time split with clean, predictable data, start with Data > Text to Columns and verify the preview before applying it. Choose TEXTSPLIT when the output should update as the source changes and the delimiter pattern is simple. If the text contains embedded delimiters, inconsistent rows, or values that must retain exact formatting, preserve a backup and use a method that can handle those details rather than trusting a basic split.
Related
- Excel Scenario Manager: How to Create and Compare Cases
- Scenario Manager and Data Tables in Excel
- Scatter Plot in Excel With 3 Variables: How to Make One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Double Space Between Words in WordTo put two spaces between words in Microsoft Word, open Home > Replace, enter one space in Find…
- How to Open an AIS JSON File in ExcelTo open an AIS JSON file in Excel, import it with Power Query: in Excel for Microsoft 365…
- Google Sheets Filter Custom Formula: How It WorksYes. In Google Sheets, choose Data > Create a filter, open a column’s filter menu, then select Filter…
- Excel Remove Duplicates Based on Two ColumnsTo remove duplicate records based on two columns in Excel for Microsoft 365 on Windows, select the entire…
- Change Text to Lowercase in Excel: Steps and Tips That WorkTo change text to lowercase in Excel, enter =LOWER(A2) in a blank helper cell when the text to…
- Key Schedule Template Excel: Build One That WorksA key schedule template in Excel can track important activities, who owns them, when they are due, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.