TEXTAFTER

TEXTAFTER extracts the portion of a string that comes after a specified delimiter character or substring. It is ideal for parsing structured strings such as email addresses, file paths, or delimited fields where you need everything after a known separator.

Excel

=TEXTAFTER(A2,"@")

Google Sheets

=TEXTAFTER(A2,"@")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Identify the source text cell (e.g., A2 containing 'user@example.com') and the delimiter you want to split on (e.g., '@').
2Enter =TEXTAFTER(A2,"@") to return everything after the first '@', giving 'example.com'.
3Use the optional instance_num argument (e.g., 2) to target a later occurrence, or set match_mode to 1 for case-insensitive matching.

Need a version for your data?

Try: “Extract the domain name from a list of email addresses”

TEXTJOIN LEFT / RIGHT / MID TRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

TEXTAFTER

Try it with your data

How it works

Related