How do I easily combine multiple cells from Excel into a single cell?

If I have a couple thousand contact records in excel with columns with values of "First Name", "Last Name", and "Title" how could I combine those values into a column called "Contact" in the same row?

Microsoft Excel 2007

3 Answers

First create a new column, in that use the CONCATENATE function, like so:

=CONCATENATE( A1 , B1 , C1 )

This function basically sticks words togther, so if you've got "Mr", "John" and "Smith" in A1, B1 and C1 the result would be "MrJohnSmith".

This is easy to fix by adding extra spacers to the formula, to get "Mr John Smith".

=CONCATENATE( A1 , " " , B1 , " " , C1 )

Now just copy this down the rows, do a paste special to values, and you can delete the original columns.

Use string concatenation. you will need to add spaces, too.

Assuming your current cells are A1:A5, make A6 be

=A1 & " " & A2 & " " & A3 & " " & A4 & " " & A5

The & operator combines two strings.

Another way to do it, if you have multiple rows you want to copy:

• Select rows you want and hit Copy.
• Paste rows into Notepad.
• Double click cell or hit F2 after selecting cell.
• Paste rows in cell.

It should copy all rows into one cell.