How to extract the domain from an email address
✓ Verified in LibreOffice 25.8.7.3Pull everything after the @ sign out of an email address.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =MID(A2,FIND("@",A2)+1,LEN(A2)) | FIND locates the @, MID takes everything after it. |
| Google Sheets | =MID(A2,FIND("@",A2)+1,LEN(A2)) | Identical. TEXTAFTER(A2,"@") also works in newer versions. |
| LibreOffice Calc | =MID(A2,FIND("@",A2)+1,LEN(A2)) | Identical. |
How it works
FIND("@",A2) returns the position of the @ sign. Adding 1 starts one character later, and MID pulls that many characters through the end of the string (LEN(A2) is a safe upper bound). For 'jane.doe@example.com' the result is 'example.com'.
Verified, not just documented
We ran =MID(A2,FIND("@",A2)+1,LEN(A2)) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned example.com — exactly the expected result. Every formula here is confirmed by actually executing it.