Ever wondered how to combine a cell in Excel in 2026? Here’s the thing sometimes you want to join text from two cells. Or just glue a few bits of info together. This one trick saves so much time.
There’s merge stuff and combine stuff… and they’re kinda different. Let’s walk through the easy bits.
What Does “Combine Cells” Even Mean?
In Excel, “combine” usually means put the contents of two (or more) cells into one cell without losing anything. That’s not the same as merging merging can remove extra content.
So yeah we’re going to focus on keeping all of your text, not just one line.
Quick Tip: Basic Combine Methods
Here are the main ways folks do it:
- Ampersand (&) operator simple & quick
- CONCAT / CONCATENATE functions tidy formulas
- TEXTJOIN best when you have many cells
These work in Excel 365, Excel 2024, Excel 2021, and Excel 2019 too.
1) The Ampersand Trick (&)
Here’s a real example. My buddy Sam had two columns first name and last name and he wanted one full name. He typed this:
=A2 & ” ” & B2
Hit Enter… boom Sam Jones in one cell.
Not fancy. But it works.
Real simple:
- Click the cell where you want the result.
- Type =, then click the first cell.
- Type &” “&, then click the next cell.
- Press Enter.
2) CONCAT or CONCATENATE Function
Same idea, different word:
=CONCAT(A2, ” “, B2)
Or older Excel versions might use:
=CONCATENATE(A2, ” “, B2)
Start typing in a new cell. Excel will auto-help you fill in the bits.
This is nice when:
- You want to add commas (“, “)
- You want to include extra text (“Name: ” & A2)
3) TEXTJOIN Best for Lots of Cells
Suppose you have three, four, five pieces of text. TEXTJOIN lets you:
=TEXTJOIN(” “, TRUE, A2:C2)
That just says:
join these cells with a space, and ignore any that are blank.
Super handy if your data’s messy.
Merge Cells But Watch Out
There’s also the Merge & Center button in the toolbar.
That makes one giant cell out of many. But problem is:
- Excel keeps only the top-left text
- All the other text disappears
So yeah that’s only useful for layout or headers, not for combining data.
Quick version:
- Home → Merge & Center
- Or click the arrow next to it for more merge options
But again this won’t bring text from other cells with it.
Snippet-Friendly Cheatsheet
Here’s a quick list you can steal and keep handy:
- =A1 & B1 → Join text with no space
- =A1 & ” ” & B1 → Join with a space
- =CONCAT(A1, ” – “, B1) → Join with a dash
- =TEXTJOIN(” “, TRUE, A1:C1) → Join many cells with space
Mini Story Why I Use TEXTJOIN
Quick story last week I was cleaning up a list of city names and codes. I tried ampersand first… got tangled strings. Then TEXTJOIN? A few clicks and every city, code, region tag was in one tidy cell. Felt good. Sometimes this stuff feels like magic, yeah?
FAQ’s
Q: Can I merge cells without losing text?
A: Not with the merge button but using functions or TEXTJOIN you keep all the content.
Q: What’s the easiest way to combine text?
A: The & operator quick and dirty, right?
Q: What if some cells are empty?
A: TEXTJOIN ignores blanks if you tell it to (TRUE) super useful.