Merge names for email in Excel

If need to take a list of names in Excel and turn them into email addresses for Outlook (active directory), here are two options!

 

Option 1 - First and last names are in two separate columns starting in A1:

1) Insert a new column to the right and use Concatenate

2) In the formula bar type =A1&" "&B1 (note the space between the double quotes)

3) Double click AutoFill handle (in the cell's bottom right corner) to...

4) ...copy the formula down to the bottom of the data

5) Copy and paste the column of formula as Value (right click and choose the option with 123)

Option 2 - First and last names are in column F, separated with a comma:

1) Insert a new column to the right and use multiple functions

2) In the formula bar type:

=RIGHT(F1,LEN(F1)-LEN(LEFT(F1,FIND(",",F1)-1))-2) & " " & LEFT(F1,FIND(",",F1)-1)

(this will also work if there is a middle initial)
3) Double click AutoFill handle to...

4) ...copy the formula down to the bottom of the data

5) Copy and paste the column of formula as Value (right click and choose the option with 123)

Trainer Lori's channel on YouTube