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:
- Open the desired excel sheet where E-mail addresses are saved or you can make a new one.
- Type the name manually for the first row next shell to the existing shell.
- When you will type the name for the second row, you will see a list of the name is visible.
- 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 https://cloud.foetron.com/ or you can directly mail us at support@foetron.com. Check out our website www.foetron.com to know about the services offered by us.