In this video, we will learn about Flash fill feature in excel. If you have a list of email addresses and want to separate them into first name and last name. To do so, follow this:

  1. Open the desired excel sheet where E-mail addresses are saved or you can make a new one.
  2. Type the name manually for the first row next shell to the existing shell.
  3. When you will type the name for the second row, you will see a list of the name is visible.
  4. Press Enter to fill out all the name automatically.

For any other concerns related to Office 365 plan and subscriptions. You can reach out to us by submitting a ticket on our portal or you can directly mail us at Check out our website to know about the services offered by us.