Use =left and =concatenate to create a list of email addresses from Excel

Most companies use a uniform format for their email addresses, either first letter of first name with the last name or first dot last name.

This video shows you how to use Excel functions =left and =concatenate to automatically generate a list of email addresses.

For more excel techniques see our Excel Training Class.