You're a marketing analyst doing a domain-by-domain breakdown of inbound leads. Column A (Email) has 12 raw email addresses; the analytics tool only ingests the domain part (everything after the @).
Example: sarah.smith@gmail.com → gmail.com.
Your task:
- In column B (Domain), write a formula that returns just the domain for each row.
- The formula must drag-fill from B2 → B13.
The standard pattern: find the position of @ with FIND, then slice everything after it. MID(A2, FIND("@", A2)+1, LEN(A2)-FIND("@", A2)) reads the substring from @+1 to the end. The equivalent with RIGHT: RIGHT(A2, LEN(A2) - FIND("@", A2)) — same idea, slice from the right by the number of chars after the @.
Graded cells: B2 (sarah.smith@gmail.com → gmail.com), B4 (analyst@acmecorp.com → acmecorp.com), B9 (finance@vandelay.industries → vandelay.industries).
Open this problem on a desktop to attempt it.