TEXTBEFORE
Returns the text before a marker.
How it’s written
TEXTBEFORE(text, marker)Example
| A | |
|---|---|
| 1 | |
| 2 | amara@x.com |
=TEXTBEFORE(A2,"@")Result: amara
Returns everything before 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 LEFT and FIND instead.
Practice it properly
Splitting at a marker gives you real tasks, with your formulas tested on data you haven’t seen.