How to create a list of emails from a list of names.
We want to create an email address for every employee in our company. We have just a list of names. How to find a way to not write for everyone their email address in the B column???
Let's go with the Autofill trick.
We have to write the first email address. It will be "firstname.lastname@example.org". After writing the first email address press enter and then, here the magic happens :P, CTRL + E
This type of auto-fill works only in Excel 2013 so if you try it in Excel 2010 or later nothing will happen. But don't worry I have the right trick for you