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.

A sample contact sheet shows the source email in A2 and the extracted example.org in B2.

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.

Three sample rows distinguish a clean address, a value without an at sign and one with two separators.

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.

Microsoft’s TEXTAFTER documentation.