FinanceTier 312 minintermediate

Extract the Domain from a Vendor Email

Pull the domain out of a vendor contact email whose length varies from row to row.

What you will learn

• Locate the @ symbol's position with FIND rather than assuming a fixed character count
• Extract everything after the @ using RIGHT or MID from that located position
• Explain why a fixed-position split breaks the moment the address length changes

Excel skills

FIND, RIGHT, MID, LEN · Text Cleanup

The task

Each vendor contact email combines a local part and a domain, but the domain's length varies from vendor to vendor. In B2, extract the domain (everything after the @) using the position of the @ itself, not a fixed character count.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free