When preparing a CSV file for import, it’s often useful to extract the domain from email addresses to analyze customer data, group accounts, or validate records. Instead of manually separating email domains, an advanced Excel formula can automatically extract them.
Assuming Column A contains email addresses (e.g., john.doe@example.com), use this formula:
=RIGHT(A2, LEN(A2) – FIND(“@”, A2))
How It Works:
FIND("@", A2)finds the position of the@symbol.LEN(A2) - FIND("@", A2)calculates how many characters remain after@.RIGHT(A2, ...)extracts everything after@, which is the domain (e.g.,example.com).