Excel sort by domain of email

SEO Tip: Great for reachouts of your existing customers and fitting specific promotions and emails for domain or business holders (not free email accounts)

Step 1 –
Create a new column called “email domain”

Step 2 –
Enter below code into first field while replacing BOTH ‘M2’ fields will email address field.

=MID(M2, FIND(“@”,M2, 1)+1, 255)

Step 3 –
Drag down to auto fill code

Step 4 –
Do a regular sort.