Excel Split Cell After a Character: Methods That Work

In Excel for Microsoft 365 on Windows, split a cell at a character with Data > Text to Columns, choose Delimited, and specify the separator. For a formula-based split that updates when the original text changes, use TEXTBEFORE and TEXTAFTER; use LEFT with FIND when the separator should stay at the end of the first result.

What “split after a character” means in Excel

Excel stores the contents of a cell as one value; it does not divide a cell into two independently editable cells inside the same grid position. Instead, a split puts the portions of the text into neighboring cells or returns them from formulas in separate cells. For example, splitting North-482 at the hyphen can produce North and 482 in two columns.

There is a small but important distinction between splitting at a character and splitting after it. A typical delimiter split removes the separator from the results. If the hyphen should remain with the first part, the result should instead be North- and 482. Choose the method based on whether you need a one-time rearrangement or results that recalculate as source values change.

Use Text to Columns for a one-time split

Text to Columns is usually the quickest choice when you have a list to divide once, such as names, product codes, or imported data. It writes the results into adjacent cells, so make sure those cells are empty or choose a different destination to avoid overwriting information.

Select the cells that contain the text. If you select a whole column, make sure there is room for the split results to its right.
Choose Data > Text to Columns.
In the wizard, select Delimited and choose Next.
Check the separator that appears in your data, such as Comma or Space. For another one-character separator, select Other and enter that character.
Review the preview, then choose Next. Set a destination if the default output would overwrite existing cells.
Choose a column data format if needed, then select Finish.

For example, if A2 contains North-482, choosing the hyphen as the delimiter produces North in the first output column and 482 in the next. The delimiter itself is not included in either result. The command changes the selected data into separate values; it does not leave formulas linked to the original text.

Text to Columns is available in Excel for Microsoft 365 on Windows and Mac, though the ribbon layout can vary by platform. Excel for the web does not provide the same full Text to Columns wizard in all versions; formulas are a practical alternative there. If you are using a different Excel edition, check whether the command appears on the Data tab.

Use formulas when the split should update

For Microsoft 365 or Excel 2024, TEXTBEFORE and TEXTAFTER provide a readable way to return the portions on either side of a separator. With the complete text in A2 and a hyphen as the separator, enter these in two empty cells:

With the text in A2, this returns the part before the first hyphen:

=TEXTBEFORE(A2,"-")

With the text in A2, this returns the part after the first hyphen:

=TEXTAFTER(A2,"-")

If A2 contains North-482, the first formula returns North and the second returns 482. These formulas recalculate if A2 changes. They also spill results when a formula is set up to return multiple pieces, but the examples above return one result each. TEXTBEFORE and TEXTAFTER require Microsoft 365 or Excel 2024; older perpetual versions may not recognize them.

To keep the separator at the end of the first result, use LEFT and FIND instead. With North-482 in A2, this returns North-:

=LEFT(A2,FIND("-",A2))

With the same value in A2, this returns the text following the hyphen:

=MID(A2,FIND("-",A2)+1,LEN(A2))

FIND returns the position of the hyphen, counting from the first character. LEFT takes that many characters, so it includes the hyphen. MID starts one character later, which leaves the hyphen out of the second result. These functions work in older Excel versions as well as current ones.

Split at the second or another repeated character

Some values contain the same separator more than once. For instance, 2026-11-02 has two hyphens. By default, TEXTBEFORE and TEXTAFTER use the first matching delimiter. Their optional occurrence argument lets you target a later match. With the value in A2, these formulas divide it at the second hyphen:

With the date-like text in A2, this returns everything before the second hyphen:

=TEXTBEFORE(A2,"-",2)

With the same value in A2, this returns everything after the second hyphen:

=TEXTAFTER(A2,"-",2)

For 2026-11-02, the results are 2026-11 and 02. The second hyphen is removed from the boundary between the results. If the goal is to separate year, month, and day into three cells, a split at every hyphen is more suitable than choosing only the second occurrence.

With older functions, FIND can search from a starting position. For the second hyphen in A2, use the position returned by a nested FIND as the starting point for another FIND. This method is useful when newer text functions are unavailable, but it is less readable and needs adjustment if the requested occurrence changes.

Choose the method that fits the data

Text to Columns: Best for a one-time split of a selected range. It replaces the selected values with separate results and does not update them when the source changes.
TEXTBEFORE and TEXTAFTER: Best for formulas that should remain connected to the original cell. They are available in Microsoft 365 and Excel 2024.
LEFT, MID, FIND, and LEN: Useful for compatibility with older Excel versions and for controlling whether the delimiter stays in the first result.
Power Query: Useful when you repeatedly import and clean a larger data set. It can split a column by a delimiter as part of a refreshable transformation.

For a regular import that must be cleaned again next week, Power Query can be more dependable than repeating a manual split. In Excel for Windows, select the data and choose Data > From Table/Range to open the Power Query Editor. Select the column, then use Home > Split Column > By Delimiter or the equivalent command on the Transform tab, depending on the editor layout. Choose whether to split at the left-most, right-most, or each occurrence when those options are offered, then close and load the results. Exact labels can vary with Excel updates.

Handle missing, uneven, or more complex separators

A formula that searches for a separator can return an error if a particular row does not contain it. That is common in mixed data, such as a list where only some codes include a suffix. If the desired behavior is to leave the original value unchanged when no hyphen exists, with the text in A2 use:

=IFERROR(TEXTBEFORE(A2,"-"),A2)

With the text in A2, this returns the text after the hyphen when one exists and a blank when one does not:

=IFERROR(TEXTAFTER(A2,"-"),"")

Decide what a missing separator should mean before filling a formula down. Returning the original value, a blank, or an error are different choices, and the right one depends on whether missing separators are expected or indicate bad input.

Spaces can also cause surprising results. A value such as North - 482 has spaces around the hyphen, so splitting on the hyphen leaves a trailing space in the first piece and a leading space in the second. You can clean the results with TRIM. With the text in A2, this removes extra spaces from the part before the hyphen:

=TRIM(TEXTBEFORE(A2,"-"))

TRIM removes leading and trailing spaces and reduces repeated internal spaces to single spaces. Do not use it if repeated spaces are meaningful in the source. For multi-character separators such as ::, formulas can use the full string as the delimiter, while the Text to Columns wizard is designed around individual delimiter characters; formulas or Power Query may be a better fit.

Common problems and how to avoid them

Neighboring data disappears: Text to Columns writes results into cells beside the source. Inspect the destination area first, or set an unused destination in the wizard.
The delimiter is missing from the output: This is normal for a standard delimiter split and for TEXTBEFORE/TEXTAFTER. Use LEFT with FIND when you want it included at the end of the first piece.
A formula returns an error: Check that the character matches exactly, including spaces, and decide how to handle rows that lack the separator.
Numbers or dates change appearance: Text to Columns can interpret output as numbers or dates. Use the wizard preview and column data format options when preserving text is important, especially for leading zeros in codes.
Results do not change after editing the source: Text to Columns creates values, not a live link. Use formulas or a refreshable Power Query process when updates matter.
The split happens at the wrong occurrence: A basic delimiter split generally acts on every occurrence in Text to Columns, while the simple TEXTBEFORE/TEXTAFTER formulas use the first. Specify an occurrence with their optional argument when appropriate.

Frequently Asked Questions

Can Excel split one cell into two cells?
Excel cannot subdivide one grid cell into two independent cells. It can put the text portions into adjacent cells with Text to Columns, or return them from formulas in separate cells.

How do I split text after a comma and keep the comma?
With the text in A2, use =LEFT(A2,FIND(",",A2)) for the first result, which includes the comma. For the second result, use =MID(A2,FIND(",",A2)+1,LEN(A2)).

How do I split a cell at the first space?
In Microsoft 365 or Excel 2024, use =TEXTBEFORE(A2," ") for the first part and =TEXTAFTER(A2," ") for the remaining text. If names can contain multiple spaces, decide whether you mean the first space or the last name boundary before applying a formula.

Can I split text at every occurrence of a character?
Yes. Text to Columns can divide a range at each occurrence of the selected delimiter. In Microsoft 365 or Excel 2024, TEXTSPLIT can also return pieces separated by a chosen character; it is useful when you want the result to be formula-driven.

Does Text to Columns update when the original cell changes?
No. It writes the split pieces as values. Use formulas for results that recalculate with the source, or Power Query when you want to repeat a data-cleaning process by refreshing it.

Final choice

For a quick, one-time split, use Data > Text to Columns and check the output destination before finishing. For a split that must update, use TEXTBEFORE and TEXTAFTER in current Excel, or LEFT, MID, and FIND for broader version compatibility. When the separator needs to remain in the first piece, build the split around its position rather than relying on a delimiter command that removes it.

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.