# How to extract text after a character in Excel

Use =TEXTAFTER(A2,"@") in Excel 365. In any version, =MID(A2,FIND("@",A2)+1,LEN(A2)) returns everything after the character.

**Excel:** `=TEXTAFTER(A2,"@")` (Excel 2024 and Microsoft 365)

**Google Sheets:** `=REGEXEXTRACT(A2,"@(.+)")`

## Example

Sample data (row 1 is the header):

| A | B |
| --- | --- |
| Email | Domain |
| lena.park@northwind.example |  |
| omar@contoso.example |  |
| p.shah@fabrikam.example |  |
| tom.becker@litware.example |  |
| ines@adatum.example |  |

Formula in B2, filled to B6: `=TEXTAFTER(A2,"@")`

Result: northwind.example; contoso.example; fabrikam.example; litware.example; adatum.example

## How it works

TEXTAFTER returns what comes after the delimiter. In Google Sheets, `REGEXEXTRACT(A2,"@(.+)")` returns the part of the text matched by the brackets: one or more characters after the @.

## Other ways

- `=MID(A2,FIND("@",A2)+1,LEN(A2))`: Works in every version: start one character after the @ and take up to the full length (MID stops at the end).
- `=RIGHT(A2,LEN(A2)-FIND("@",A2))`: Counts how many characters follow the @ and takes that many from the right.

## Common mistakes

- If the character can appear more than once, TEXTAFTER uses the first by default. Use an instance number, like `TEXTAFTER(A2,".",-1)` for after the last dot.
- A missing delimiter returns #N/A. Give TEXTAFTER a fallback in its sixth argument.

## Questions

**How do I get the text before the @?**

Use `=TEXTBEFORE(A2,"@")`, or `=LEFT(A2,FIND("@",A2)-1)` in older versions.

**How do I extract text between two characters?**

Nest them: `=TEXTBEFORE(TEXTAFTER(A2,"@"),".")` returns the part between the @ and the next dot.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-29.

Source: https://spreadsheetpractice.com/formulas/extract-text-after-a-character