Concatenation & Email

Having a spreadsheet of employee names is great, but what if you want to use your data for sending emails? Concatenation to the Rescue!

Let’s say you have a list of employees with the First Names in column A and Last Names in column B. Combining them into an email-friendly column of names in a “Last Name, First Name” format is easy. Here’s how:

Assuming your table starts in cell A1, put the following formula in C1:

=B1&", "&A1

This combines the contents of B1 (last name) with a comma, space, and contents of A1 (first name). Drag the formula down to fill Column C, copy, and paste into Outlook. Presto! You have your mailing list!