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.)

C1-T C2-T C3-T
Last First First and Last
Allen Jo Jo Allen
Lee Max Max Lee
Gonzales Maria Maria Gonzales
Jones Graham Graham Jones
Spitz Roberto Roberto Spitz

Where to find this command

To concatenate text columns, choose Data > Concatenate.