Splitting Full name and creating email cell

[Mikelowrey]

Hi, I have a list of about 40,000 names that I would like to be able to split. Right now I have:

Smith, John
Doe, Jane A

I would like to separate first and last into their own cells, remove the middle, and then have that first and last be added to another cell as jane.doe so that I can add to all of them @email.com

Let me know if I need to further clarify. Thank you!

 

[alansidman]

Use Flash Fill

Save time with Flash Fill - Microsoft Support

Training: Use Flash Fill in Excel for the web to save time.

support.microsoft.com

 

[Mikelowrey]

Use Flash Fill

Save time with Flash Fill - Microsoft Support

Training: Use Flash Fill in Excel for the web to save time.

support.microsoft.com

Thank you Alan, that worked!

Last Question: How can I remove the middle initial that is together with the first name in the first name cell?

 

[alansidman]

You will need to do the example in the flash fill for at least two rows showing that the middle initial is missing for the second row for Excel to learn correctly.