Combine two or more columns by using the CONCATENATE function

Suppose you have two or more columns of data that you want to combine in a single column, such as first names and last names. You can combine them using the CONCATENATE function in a formula in a nearby cell (typically to the right of the last column of data that you want to combine).

Combine two cells of data into one

When you create your formula, you can add a space or comma to separate names and addresses in the new column by enclosing them in quotation marks (" ").

When you’re happy with your formula, drag the right corner of the cell with the formula down through the rows that contain the data.

Drag the right corner down to combine more cells

Example

The formula in the following example uses the CONCATENATE function to combine the contents of three cells in columns A, B, and C. In the function, you separate the strings that you want combined by commas. To add a space between the strings, include a space enclosed in quotation marks (" "). If you look closely at the CONCATENATE function in the formula, you’ll see that the contents of A2 are combined with a space, the contents of B2, another space, and the contents of C2.

The workbook below shows an example of this function. Inspect or change the existing formulas, or enter your own formulas to learn how the function works.

Copy the example data in the following table, and paste it in cell A1 of a new worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

First Name

Last Name

Phone

Results

Formula

Terry

Adams

555-2306

=CONCATENATE(A2," ",B2," ",C2)

=CONCATENATE(A2," ",B2," ",C2)

Steve

Riley

555-1875 ext. 2007

Steve Riley 555-1875 ext. 2007

=CONCATENATE(A3," ",B3," ",C3)

The CONCATENATE function combines column A, a space character (enclosed in quotation marks, like this: " "), column B, another space character, and column C into column D.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×