Extract Domain from Email Address
So I did an email distribution from my spreadsheet. Then 15 emails bounced back from comcast.net.It seems to happen with some frequency and my email provider has no explanation.
=MID(L2,(FIND("@",L2)+1),30)
Where L2 is column containing email addresses. Find the position number for the @ symbol and add 1. So, MID picks up that position and shows me the next 30 characters.
So I filled down. Got a list of all the domains. I alphabetized the list and now knew who I needed to contact individualy.
|