How to append "@lehigh.edu" to a column of Lehigh User IDs in Excel, using the Concatenate function

Step 1:   Open your Excel file and review the User ID column.  Ensure that there are no blank cells before continuing.

Step 2:   Insert two new columns to the right of the User ID column

Step 3 :  Position the cursor in the field to the right of the first User ID and enter '@lehigh.edu

                Note:  A single apostrophe must precede this text.

Step 4 :    Use Autofill to copy "@lehigh.edu" to the end of the list of User IDs. To do this, align the cursor at the bottom, right corner

of cell B2 (as below), then drag the cursor to cell B7 and release. 

This will automatically fill all of Column B with "@lehigh.edu."

Step 5 :   Position the cursor in cell C2 and enter =concatenate(A2,B2), then press Enter.

Notice the result in cell C2 is a combination of the User ID + @lehigh.edu, to make a complete address.

Step 6:   Use the Autofill technique again to copy the concatenate formula to the rest of the cells in Column C.

Align the cursor at the bottom, right corner of cell C2 (as below), then drag the cursor to cell C7 and release. 

This will automatically fill all of Column C with the combined value of Column A (User ID) and Column B (@lehigh.edu).

Return to "Mass Mailing the Easy Way"

kmm3, Last updated January 19, 2006