Extract Domain Name from Email Addresses Instantly
=RIGHT(A2, LEN(A2) - FIND("@", A2))This formula works by first locating the exact position of the '@' symbol within your cell using the FIND function. Once the position is identified, the LEN function calculates the total character count of the email, allowing the RIGHT function to capture only the text string occurring after that delimiter.
Simply replace 'A2' in the formula with the cell reference containing your email address. It is the fastest way to clean up contact lists, segment lead data by company, or prepare your spreadsheet for pivot table analysis without manual typing or complex text-to-column wizardry.