How To Combine 2 Cells In Excel

Combining 2 cells in Excel is a common task used to join text from separate cells into one cell, such as combining first and last names, street address and city, or product name and ID. Excel provides several ways to do this, including formulas like &, CONCAT, TEXTJOIN, and the & operator, depending on whether you want a simple combination, added spacing, custom separators, or more advanced text handling That's the part that actually makes a difference. That's the whole idea..

Understanding What “Combine Cells” Means

Before using a formula, it is important to understand that combining cells in Excel can mean two different things:

1. Merging cells visually
   This means selecting two or more cells and combining them into one larger cell for formatting purposes. The content of one cell may be kept, but the other cell’s content can be hidden or deleted depending on the action you choose That alone is useful..

2. Combining cell values into one result
   This means taking the data from two cells and placing it together in a new cell. As an example, if cell A1 contains John and cell B1 contains Smith, combining them could create John Smith Not complicated — just consistent. Less friction, more output..

For most data work, you probably want to combine the values using a formula rather than merging cells visually.

Method 1: Combine 2 Cells Using the Ampersand Symbol

The simplest way to combine two cells in Excel is to use the ampersand symbol, &.

Basic Example

Suppose you have this data:

To combine both cells in cell C1, enter this formula:

=A1&B1

The result will be:

JohnSmith

This works because the & symbol tells Excel to join the contents of two cells.

Adding a Space Between the Cells

If you want a space between the values, add a space inside quotation marks:

=A1&" "&B1

The result will be:

John Smith

This is one of the most common formulas for combining names, labels, and short text fields.

Combining Cells With a Hyphen

You can also add punctuation between two cells:

=A1&"-"&B1

Here's one way to look at it: if A1 contains A101 and B1 contains Red, the result will be:

A101-Red

This is useful for creating product codes, reference numbers, or combined labels Which is the point..

Method 2: Combine 2 Cells Using the CONCAT Function

Excel also has a built-in function called CONCAT, which combines text from multiple cells Not complicated — just consistent..

Basic CONCAT Formula

To combine cells A1 and B1, use:

=CONCAT(A1,B1)

The result will be:

JohnSmith

To add a space between them:

=CONCAT(A1," ",B1)

The result will be:

John Smith

The CONCAT function is useful when you want a formula-based approach that is easy to read. It works well for combining two or more cells.

Method 3: Combine 2 Cells Using TEXTJOIN

The TEXTJOIN function is especially useful when you want to combine multiple cells while adding a separator Simple, but easy to overlook..

Basic TEXTJOIN Example

To combine two cells with a space between them:

=TEXTJOIN(" ",TRUE,A1,B1)

This formula means:

• " " is the separator.
• TRUE tells Excel to ignore blank cells.
• A1,B1 are the cells being combined.

To give you an idea, if A1 contains John and B1 contains Smith, the result is:

John Smith

Why TEXTJOIN Is Useful

TEXTJOIN is helpful when you may have blank cells. Here's one way to look at it: if A1 is blank and B1 contains Smith, this formula:

=TEXTJOIN(" ",TRUE,A1,B1)

will return:

Smith

Without the TRUE option, Excel may include extra spaces.

Method 4: Combine Cells While Keeping Numbers in a Specific Format

Sometimes cells contain numbers, dates, or currency values. If you combine these directly, Excel may display them in a format you do not expect.

As an example, if A1 contains 12 and B1 contains 34, this formula:

=A1&B1

will return:

1234

If you need to format the number before combining it, use the TEXT function Turns out it matters..

Example With Formatting

Suppose A1 contains the date 5/17/2026 and B1 contains the text Project A.

To display the date as May 17, 2026 and combine it with the project name, use:

=TEXT(A1,"mmmm d, yyyy")&" - "&B1

The result might be:

May 17, 2026 - Project A

The TEXT function changes how the date or number appears before Excel combines it with the other cell.

Method 5: Use Flash Fill to Combine Cells Quickly

If you are combining cells in a repeated pattern, Excel’s Flash Fill feature can be very helpful.

Example: Combining First and Last Names

Assume your sheet has two columns:

You want to create a full-name column in column C.

1. In C1, type the result manually: John Smith.
2. In C2, type the next result manually: Maria Garcia.
3. Select cell C3.
4. Press Ctrl + E.

Excel will detect the pattern and fill the rest of the column automatically Small thing, real impact..

Flash Fill is a fast option when you want to combine cells without writing formulas. That said, formulas are usually better if your data may change later.

Method 6: Combine Cells Using Power Query

For larger datasets, Power Query is a powerful tool for combining columns. It is especially useful when working with repeated imports, cleaning data, or preparing reports.

Basic Power Query Steps

1. Select your data range.
2. Go to the Data tab.
3. Click From Table/Range.
4. In Power Query, select the columns you want to combine.
5. Use Merge Columns from the Transform tab.
6. Choose a separator,