TEXTAFTER
Returns the text after a marker.
How it’s written
TEXTAFTER(text, marker)Example
| A | |
|---|---|
| 1 | |
| 2 | amara@x.com |
=TEXTAFTER(A2,"@")Result: x.com
Returns everything after the @.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Newer function. Older versions of Excel need RIGHT, LEN and FIND instead.
Practice it properly
Splitting at a marker gives you real tasks, with your formulas tested on data you haven’t seen.