If you’ve spent much time in Excel, you’ll know the pain that comes with creating a large spreadsheet, only to realize it needs adjusting. Thankfully, though, this doesn’t always need to be time-consuming.

If you’re wondering how to combine two cells in Excel, you can use the concatenate command to do so without data loss.

At least, it will do so with one caveat: the two cells you’re looking to combine must be text. The most common use is likely to combine two “First name” and “Last name” columns into a single “Full name” one.

Advertisement

Excel: Combine cells / merge cells with “concatenate”

If you’re wondering, then, concatenate is simply a synonym for “Combine”, or “join together”. Why didn’t Microsoft simply call it one of those? It’s anyone’s guess, but mine is to distinguish between concatenating and the existing “merge” too, which creates a single column out of two neighboring ones.

Anyway, with that tangent over, there’s how to combine cells in Excel with concatenation:

How to Combine Two Cells in Excel with Concatenate

Concatenating allows you to create a new column that references existing data on your spreadsheet to create a new combined cell. The cells it pulls from do not have to be next to each other, though this may make it easier to organize.

Here’s how you can perform concatenation in Excel:

  1. Type the CONCATENATE formula in your cell
     

    In the cell where you’d like the combined result to display, type =CONCATENATE(.

  2. Click on the cells you’d like Excel to combine
     

    After you open your bracket, click the starting cell, followed by the cell you’d like to combine it with. Close the bracket when you’re done.

  3. Press Enter to Concatenate the cells
     

    You’ll see the two strings directly next to each other with no space. If you’d like to add a space, continue to the next step.

  4. Optional: Add a space to your concatenation
     

    You’ll want many strings you combine to have a space between them. This can be easily achieved by adding " " between the two cells the formula. Your final formula would look something like this:

    =CONCATENATE(B2," ",A2)

  5. Press Enter to apply the concatenation
     

     

  6. Optional: Copy your formula to other rows in your column
     

    If you need to apply the formula to other cells in your column, don’t waste your time copy and pasting. Instead, click the original cell, then click on the green dot in its bottom right corner and drag it down.

  7. Release your mouse button to fill the rest of the rows
     

    The concatenate will automatically apply to them, moving incrementally down the columns you specified in your formula.

There you have it. You should now know how to combine cells in Excel even if they’re on completely different sides of your spreadsheet.

If you found this useful, you may want to try some of our other Excel tutorials. For example, you can learn how to remove duplicate rows or password protect your document.

Advertisement