Excel 365 + Google Sheets · TEXTAFTER
Cut any text after a character
Returns everything after the character you choose.
The formula
=TEXTAFTER(A2, "@")What each part means
A2The text"@"Cut after this
Example
| A | B | |
|---|---|---|
| 1 | Company | |
| 2 | laura.gomez@acme.com | |
| 3 | joao@brasilco.br | |
| 4 | priya.s@tech.in | |
| 5 | tom@shop.co.uk |
| A | B | |
|---|---|---|
| 1 | Company | |
| 2 | laura.gomez@acme.com | acme.com |
| 3 | joao@brasilco.br | brasilco.br |
| 4 | priya.s@tech.in | tech.in |
| 5 | tom@shop.co.uk | shop.co.uk |
Step by step
- Click cell B2.
- Type the formula:
=TEXTAFTER(A2, "@") - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Excel 365 and Excel 2021 or newer
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English TEXTAFTER
- Español TEXTODESPUES
- Português TEXTODEPOIS