The mailing list needs a quick count by domain, and you still need the full addresses for review. Put the domain in a helper column and keep the source intact.
Split the clean part of the list
In Excel or another editor that supports TEXTAFTER, put [email protected] in A2 and enter the following in B2.
=TEXTAFTER(A2,"@")The result is example.org. Copy the formula down through rows you have already checked for a single separator. If the group should be case-insensitive, use =LOWER(TEXTAFTER(A2,"@")) and keep the original address beside it.

Example helper column. Keep the full address available next to the extracted value.
Keep ambiguous addresses in a review group
Test events.example.org and events@@example.org. The first lacks the delimiter and normally gives #N/A. The second can return text after the first separator, even though it should go to review. Treat pasted display names or angle-bracketed addresses as a separate input format.

Example review queue. An extracted string alone does not establish that the input is a valid address.
Filter the helper for one known domain and compare several rows against the original addresses before using the domain counts.



