Yes. In Microsoft 365, use TEXTBEFORE to return the text before the first delimiter and TEXTAFTER to keep everything after it intact. With the original text in A2, =TEXTBEFORE(A2,"-") returns North from North-Region-2026; the matching after-delimiter formula returns Region-2026, not just the next segment.
How TEXTBEFORE and TEXTAFTER handle a delimiter
TEXTBEFORE and TEXTAFTER are the most direct way to split a string once without changing the source value. TEXTBEFORE returns the portion before a matching delimiter; TEXTAFTER returns the portion after it. By default, each function uses the first matching delimiter it finds when searching from the beginning of the text. The rest of the string remains together, even if it contains more copies of the delimiter.
With the source text North-Region-2026 in A2 and a hyphen as the delimiter, enter this in B2 to get the first part: =TEXTBEFORE(A2,"-"). The result is North. With the same cell layout, enter this in C2 to get all text after the first hyphen: =TEXTAFTER(A2,"-"). The result is Region-2026. The two formulas therefore make a two-part split, rather than separating all three segments.
These functions are available in Microsoft 365 and Excel 2024. They are not available in Excel 2021 or earlier perpetual versions, so a workbook containing them may show a #NAME? error when opened in an older Excel edition. If a file will be used by people with different versions, check their compatibility before relying on newer functions.
Split the first delimiter in a worksheet
For a simple list, place the original strings in one column and use adjacent columns for the two outputs. For example, put North-Region-2026 in A2, the first segment in B2, and the remainder in C2. Enter the appropriate formula in row 2, then use the fill handle or copy and paste to apply it to other rows. Because the formulas refer to A2, Excel adjusts the reference to A3, A4, and so on when you fill down.
- Choose the delimiter that marks the boundary, such as a hyphen, comma, slash, or colon.
- Put the original text in a cell such as A2, and make sure the cells to its right are empty for the results.
- Use TEXTBEFORE for the left portion and TEXTAFTER for the remainder.
- Check a few rows, especially those with missing or repeated delimiters, before filling the formulas through the full list.
The formula works on the text in a cell; it does not edit or replace the source. That is useful when the original needs to remain available for checking, or when incoming data changes and the result should update automatically. If the output needs to be fixed rather than recalculated, copy the formula results and use Paste Special > Values.
When you want every segment instead
TEXTSPLIT is designed for splitting at every occurrence of a delimiter. It is not the right function when the requirement is specifically to stop at the first occurrence. With North-Region-2026 in A2, the formula =TEXTSPLIT(A2,"-") spills North, Region, and 2026 into neighboring cells. This can be convenient when each segment belongs in its own column, but it produces a different result from TEXTBEFORE plus TEXTAFTER.
TEXTSPLIT also supports row delimiters and optional settings for empty fields and matching. For a basic one-character delimiter, its first argument is the source text and its second is the column delimiter. Results spill into cells, so the destination area must be clear. If any cell in the spill range is occupied, Excel can return a #SPILL! error. TEXTSPLIT is available in Microsoft 365 and Excel 2024, not Excel 2021 or older perpetual editions.
There is a related distinction in the Data tab. Data > Text to Columns is a worksheet tool that can divide a selected column using a chosen delimiter, but its usual delimited workflow separates at each occurrence. It is useful for one-time conversion of a whole column, while TEXTBEFORE and TEXTAFTER are better suited to a repeatable formula that preserves everything following the first boundary.
Older Excel formula alternatives
If TEXTBEFORE is unavailable, FIND locates the first occurrence of a delimiter, and LEFT can return the characters before it. With the source text North-Region-2026 in A2, put this in B2: =LEFT(A2,FIND("-",A2)-1). The result is North. FIND returns the hyphen’s position, which is 6; subtracting 1 makes LEFT return the five characters before it.
To get the remainder after that same first hyphen in an older Excel version, use MID. With North-Region-2026 in A2, put this in C2: =MID(A2,FIND("-",A2)+1,LEN(A2)). The result is Region-2026. FIND identifies the first hyphen, adding 1 starts the extraction at the next character, and LEN supplies a length large enough to reach the end of the string.
FIND returns an error if the delimiter is absent. If the intended fallback is to keep the original text when no hyphen exists, wrap the newer function in IFERROR. With source text in A2, use =IFERROR(TEXTBEFORE(A2,"-"),A2). If A2 contains NorthRegion with no hyphen, the result is NorthRegion. For an older Excel version, the same fallback pattern can wrap the LEFT and FIND expression: =IFERROR(LEFT(A2,FIND("-",A2)-1),A2). Decide deliberately whether a missing delimiter should return the whole value, a blank, or an error, because those choices can affect later calculations.
Choosing the right delimiter and result
The delimiter must match the actual characters in the data. A hyphen-minus (-), an en dash (–), and an em dash (—) look similar but are different characters, so a formula searching for one will not find the others. Spaces also count: a delimiter of comma followed by a space is not the same as a comma alone. When data comes from several sources, inspect examples or use Find to identify whether punctuation and spacing are consistent.
Think about what the first delimiter means in the data structure. In a code such as Dept-West-482, the first hyphen may mark the boundary between a department and a location, while the later hyphen separates a number. Splitting once keeps West-482 together. In an address or a file path, however, the first separator may not always represent the useful boundary. Confirm the rule against varied rows before applying it to a large dataset.
If the goal is instead to split at the last delimiter, TEXTBEFORE and TEXTAFTER allow a negative instance number. With Dept-West-482 in A2, =TEXTBEFORE(A2,"-",-1) returns Dept-West, because -1 identifies the last hyphen from the end. With the same cell layout, =TEXTAFTER(A2,"-",-1) returns 482. This is a useful contrast: the default is the first delimiter, while a negative instance number selects an occurrence counted from the end.
Common problems and checks
- #NAME? Usually means Excel does not recognize a function name, commonly because TEXTBEFORE, TEXTAFTER, or TEXTSPLIT is not available in that Excel version.
- #N/A from TEXTBEFORE or TEXTAFTER: The requested delimiter may not appear in the source. Decide whether to handle that with IFERROR, an optional not-found argument, or a visible error.
- Unexpectedly short result: A delimiter may appear earlier than expected. The default finds the first matching occurrence, not a particular visual boundary that you had in mind.
- Wrong delimiter match: Check for different dash characters, hidden spaces, or inconsistent punctuation in the source values.
- #SPILL! from TEXTSPLIT: Clear the cells where the split results need to appear, or choose another starting cell.
Also check for blank source cells and values without the delimiter. A formula that returns an error for such rows may be correct according to its instructions, but undesirable for a finished report. In a shared workbook, document what should happen in those cases rather than silently hiding all errors. If a formula is copied into a structured Excel table, confirm that its output columns are included and that the table has enough room for any dynamic-array results.
Which method should you use?
Choose based on the desired output and how the data will be maintained. TEXTBEFORE plus TEXTAFTER is usually the clearest choice for a two-part split at the first delimiter. TEXTSPLIT is a better fit when every occurrence should create a separate segment. Text to Columns is handy for a one-time conversion, while LEFT, FIND, MID, and LEN can cover the first-delimiter case in older Excel versions.
- Need the part before the first delimiter: use TEXTBEFORE.
- Need everything after the first delimiter as one value: use TEXTAFTER.
- Need each delimiter-separated segment in its own cell: use TEXTSPLIT or Text to Columns.
- Need compatibility with older Excel: use LEFT and FIND for the first part, and MID, FIND, and LEN for the remainder.
The function formulas are the same in current Excel for Windows and Mac when the functions are supported. Function availability depends on the Excel version, and formula argument separators can differ with regional settings; some installations use semicolons instead of commas. Excel for the web also supports modern worksheet functions, though the layout and ribbon presentation differ from the desktop app.
Frequently Asked Questions
How do I split text after the first hyphen in Excel?
Use TEXTAFTER with the cell and a hyphen delimiter. For example, if A2 contains North-Region-2026, the result is Region-2026. TEXTAFTER returns the rest of the text after the first hyphen by default.
Does TEXTSPLIT split only at the first delimiter?
No. TEXTSPLIT normally separates at every occurrence of its delimiter, spilling the parts into cells. For one split only, use TEXTBEFORE and TEXTAFTER, or an older-compatible formula built with FIND.
Can I split at the last delimiter instead?
Yes. In TEXTBEFORE or TEXTAFTER, use an instance number of -1 to select the last occurrence. For example, TEXTAFTER with -1 returns the text after the final matching delimiter.
What if the delimiter is missing?
TEXTBEFORE and TEXTAFTER return #N/A when they cannot find the delimiter unless you provide a not-found result. IFERROR is another option; it can return the original text, a blank, or another chosen fallback.
Can Text to Columns split only once?
Its standard delimited workflow separates a column at each selected delimiter, so it is not the simplest way to retain all text after the first one. Use TEXTAFTER for a formula-driven remainder, or use a formula compatible with your Excel version.
Related
- Power Query Replace Text: Steps, Options, and Examples
- Conditional Formatting: Use More Than One Rule in Excel
- table() in RStudio: How It Counts and Displays Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clear Cache in Outlook OWA: Browser Data and FixesTo clear the cache in Outlook on the web (OWA), clear the cached files in the browser you…
- Merge Cells in Google Sheets: Steps and Data TipsTo merge cells in Google Sheets in a web browser, select the cells, then choose Format > Merge…
- How to Add Styles in Microsoft Word: A Practical GuideTo add a style in Microsoft Word, select the text and choose a style from Home > Styles;…
- How to Create a Distribution List in OutlookTo create a personal distribution list in Outlook, open People, choose New contact list in new Outlook or…
- Combine Cells in Excel With Dates Without Losing FormatTo combine a date with text without displaying its underlying serial number, use a formula that applies TEXT…
- Excel Upgrade Your Plan Prompt: How to Hide It SafelyTo hide an “Upgrade your plan” prompt in Excel, first use its close button or “No thanks” link…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.