How to get into from an email list

A user ask: I have a list of emails, where I need to separate the name and last names.

I tried with LEFT and MID, but because the length of names is different I cannot get the desire result.

Here is a solution.

Instead of using a function, we will use the smart filling tool

We just have to look for a pattern that we can follow.

The name are before the point and the last name before the at sign.

On cell C2, type the first name on this email, Lalo, then on cell D2, type Munn

Now on cell C3, press CTRL + E, then select cell D3 and press CTRL + E.

And there we have.