Overview of Concatenate

Use Concatenate to combine two or more text columns and store the result in a new column. For example, in the following worksheet, a manager has a column of employee last names (C1) and a column of employee first names (C2). The manager uses Concatenate to combine the two columns into one name column (C3). (The manager manually added the spaces between the first and last name.)