The TEXTSPLIT function will split the email at the ‘@’ character and return the name and the domain in cells ... from your email addresses, you need to manually create a pattern.

The second part is the ISP's domain name. However, if you change your service, your Internet address changes. To obtain a permanent email address, you can register your own domain name or you can ...