wetalkexcel wetalkexcel Albania Add to my favorites
Rate this tip

About Video

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 "name@abc.com". 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

=A2&"@abc.com"

SHOW MORE

Comments

Brilliant and to the point!

Reply