Numbers Text to Columns: Split Your Data Correctly

Yes. Apple Numbers can split text from one cell or column into separate columns: on a Mac, select the cells and choose Table > Split Text into Columns, then choose the separator that divides the text. For example, splitting Nguyen,Minh at the comma puts the two names into neighboring columns. Make a copy of important data first, and check that there is room for the results.

What “Split Text into Columns” does

Numbers’ command takes text containing a repeated separator and divides it wherever that separator appears. The separator is the character between fields: a comma in a comma-separated list, a tab between pasted fields, or a space between words. Each piece is placed in its own column in the table. The command is useful when a whole list has the same predictable structure, such as a column of first and last names or product codes separated by hyphens.

This is the Numbers equivalent of the general spreadsheet task often called “text to columns.” The exact command name and location differ from Microsoft Excel: in Numbers for Mac, look under the Table menu. Splitting is not the same as changing a column’s width, wrapping text, or moving a cell’s contents visually. It changes how the text is distributed among cells.

How to split a column in Numbers for Mac

Start with the source text in one table column. If your values are in a single cell, select that cell; if they are in a range, select the cells you want to process. Then use the menu command and specify the character that separates the parts.

Save the spreadsheet, or duplicate the source column so the original values remain available.
Select the cell or range containing the text to divide. Selecting just the relevant data avoids altering unrelated entries.
Choose Table > Split Text into Columns from the menu bar.
Choose the appropriate separator in the options Numbers presents, such as a comma, tab, space, or a custom character.
Review the resulting columns, especially the first and last rows, and correct any values that did not follow the expected pattern.

For instance, if A2 contains North,Warehouse 4,Active and the comma is the separator, the fields are North, Warehouse 4, and Active. The space inside “Warehouse 4” is not a problem when splitting on commas. If you instead choose a space, that location name would be divided into two pieces as well.

Menu wording or available controls can vary with the Numbers version and device. These instructions describe Numbers for Mac. On iPad or iPhone, the menus and selection controls are different; if you cannot find the same command, open the spreadsheet in Numbers for Mac rather than assuming the Mac menu path applies to the touch interface.

Choose a separator that matches the data

The most important decision is which delimiter to use. Choosing a character that appears inside a field can create too many columns; choosing one that is absent from the text may leave every value unchanged. Look at several representative rows before you split, not just the first one.

Comma: Suitable for simple comma-separated fields, such as SKU-17,Blue,12. It is a poor choice if commas also appear within descriptions.
Tab: Common in data copied from one spreadsheet or table into another. Tabs are usually invisible in a cell, so check the source format if a comma or space does not behave as expected.
Space: Useful for consistently spaced values, but risky for names, addresses, and descriptions containing multiple words.
Custom character: A pipe (|) or semicolon can be a clearer separator when it is used between fields and does not occur in the fields themselves.

Repeated separators deserve attention. Two commas in a row may mean there is an empty field, such as a missing middle value. A separator at the beginning or end may also represent a blank part. After splitting, inspect whether Numbers has preserved those empty positions as you intended; do not assume every source file uses the same convention for missing information.

Examples of useful splits

A simple example is a list of codes written as region-product-number. If each code uses hyphens consistently, splitting at the hyphen can separate its three components. Check whether any component itself contains a hyphen first: for example, a product name like eco-friendly could otherwise create an extra piece.

Names are another common case, but the data structure matters. Splitting Lee,Jordan at the comma can produce separate surname and given-name fields. Splitting Jordan Lee at a space may appear to work for two-word names, but it is unreliable for people with compound given names or surnames. A consistent comma-delimited format is safer than assuming every person has exactly two name parts.

Addresses show the same limitation. Dividing 18 Pine Road,Springfield at the comma can separate a street address from a town if that is exactly how the source is formatted. Splitting at spaces would break the street name into several cells and would not identify which words belong together. A delimiter tool follows characters; it does not understand the meaning of names, addresses, or categories.

Protect values, blanks, and formatting

Keep an untouched copy of the original column until you have checked the output. Splitting is a structural edit, and a backup makes it easier to recover if the wrong separator was selected or the source data has exceptions. Also leave enough empty columns to the right of the source. Existing table data in the destination area can make the result difficult to place or may need to be moved first, so do not run the operation over valuable neighboring cells without checking the layout.

Review how Numbers interprets values after the split. A piece that looks numeric may be treated as a number, and dates may be recognized as dates according to their appearance and settings. That can matter for identifiers such as 00482, where the leading zero is part of the code rather than a number to calculate with. Preserve the original text and verify identifiers after splitting; format destination cells as text when appropriate and correct any values that have been converted.

Formatting is separate from the split itself. After the data is divided, you can resize columns, apply number or text formats, and add headings as needed. Do not judge success only by whether the cells look tidy: compare a few results with the source to make sure punctuation, leading zeros, empty fields, and the order of the parts are intact.

Common problems and how to fix them

Nothing changes: The chosen separator may not actually be in the selected text, or the selected range may not include the cells you intended. Check a raw value and select the correct cells before trying again.
Too many columns appear: The delimiter may occur inside descriptions or names. Undo immediately if the result is wrong, then choose a safer separator or clean the source data first.
Some rows split differently: The source may contain inconsistent punctuation, extra spaces, or missing values. Correct those exceptions or separate them for manual review rather than treating the whole column as uniform.
Zeros disappear or dates change: Numbers may have interpreted the split pieces as numbers or dates. Compare with the preserved original and set the relevant destination cells to an appropriate format.
The output affects nearby data: The table may not have clear space for the added fields. Duplicate the source into a table area with room, or add columns before running the split.

If a result is wrong, use Undo promptly, before making other edits. The most common cause is choosing a delimiter that occurs more often than expected. A short trial on a duplicated sample can reveal that problem before you process a large range.

When a delimiter split is not enough

A split command is best for regular text with a clear boundary between fields. It is not a full data-cleaning system. In particular, a field may contain the same character used as the separator. Some CSV formats handle that situation by enclosing fields in quotation marks, but do not assume that a simple split operation will interpret every quoted CSV convention correctly. For a file with quoted commas, embedded line breaks, or inconsistent records, use a proper CSV import workflow and verify the imported columns rather than splitting blindly.

For irregular text, a better first step may be to standardize the source: replace inconsistent separators, remove unwanted spaces, or handle unusual rows individually. If the source is a file rather than text already in a table, importing it with its delimiter settings is often preferable because you can inspect how fields are recognized during import. If the same split must be repeated whenever source data changes, consider a repeatable data-preparation workflow instead of manually splitting each time.

Excel users may recognize a similarly named feature, but instructions are not interchangeable. In Excel for Microsoft 365 on Windows, the comparable command is Data > Text to Columns. Numbers has its own menu command and controls; follow the steps for the app in which the spreadsheet is open.

Frequently Asked Questions

Does Apple Numbers have Text to Columns?
Yes. In Numbers for Mac, select the text cells and use Table > Split Text into Columns. The command divides each value at the selected separator.

Can Numbers split text at a comma?
Yes, when commas mark the boundaries between fields. Choose the comma as the separator, then check for commas that belong inside a description or other field, since those can create unwanted extra columns.

Can I split a cell at a space?
Yes, but use a space only when it reliably marks the boundary you want. A value such as Jordan Lee can split into two parts, while a multiword name or address will split into more pieces.

Can I undo Split Text into Columns?
Use Undo immediately after the operation if the result is wrong. Keeping a duplicate of the original column is safer, especially if you have made additional edits since splitting.

Is Numbers’ command the same as Excel Text to Columns?
They solve a similar task, but they are different app features with different menus and controls. In Numbers for Mac, use Table > Split Text into Columns; Excel for Microsoft 365 on Windows uses Data > Text to Columns.

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.