How to Combine Cells in Excel: Merge, CONCAT, TEXTJOIN, and Ampersand Methods Explained

Combining cells in Excel is one of those everyday tasks that sounds simple until you actually try it. You might want to merge a header across several columns, stitch together a first and last name from two separate fields, or build a complete address from house number, street, city, and zip code that all live in different cells. Each of these goals needs a different approach, and choosing the wrong method can cost you hours of cleanup work later on.

This guide walks you through every reliable way to combine cells in Excel, from the simple Merge & Center button on the Home ribbon to powerful text functions like CONCAT, CONCATENATE, TEXTJOIN, and the ampersand (&) operator. You will also learn when each method is appropriate, what limitations to watch out for, and how to avoid the classic mistake of losing data when you merge cells that already contain values.

Whether you are studying for an Excel certification, prepping for a job interview, or just trying to clean up a messy spreadsheet at work, these techniques will give you full control over how data flows together inside your worksheet. Let's start with a quick look at the most common combine scenarios you will encounter.

The Difference Between Merging and Combining

Before you click anything, it helps to understand the distinction Excel draws between merging and combining. Merging cells joins them visually into a single larger cell, while combining stitches the contents of multiple cells into one string of text. They look similar on screen, but they behave very differently when you sort, filter, copy, or paste your data.

Merge & Center keeps only the value from the top-left cell and erases everything else. So if cell A1 contains "John" and B1 contains "Smith", merging them produces a single cell with just "John". Combining, in contrast, returns "John Smith" while leaving the original cells untouched.

For most data work, especially anything involving formulas, sorting, or filtering, combining is the right move. Merging should be reserved for cosmetic uses like centering a title across the top of a report.

Method 1: The Ampersand (&) Operator

The ampersand is the simplest way to combine cells in Excel. It works in every version going back to Excel 97 and behaves predictably in every situation. To join cell A1 and B1 with a space between them, type =A1&" "&B1 in any empty cell. The ampersand is sometimes called the concatenation operator, and it strings together whatever values, text, or cell references you place around it.

You can chain as many ampersands as you need. For example, =A2&", "&B2&" "&C2 produces something like "Smith, John Q" by combining a last name, comma-space separator, first name, space, and middle initial. The literal text inside the quotation marks becomes part of the output exactly as you type it.

One thing that trips up new users is forgetting the spaces. =A1&B1 with "John" and "Smith" gives you "JohnSmith" with no space, which is rarely what you want. Always include the separator characters inside quotation marks: =A1&" "&B1.

The ampersand also handles numbers and dates, but it converts them to text in the process. If A1 contains the date 1/1/2026, then ="Year "&A1 returns "Year 46388" because Excel stores dates as serial numbers. To fix this, wrap the date reference in the TEXT function: ="Year "&TEXT(A1,"mmmm yyyy") produces "Year January 2026".

Method 2: The CONCATENATE Function

The CONCATENATE function has been part of Excel for decades, and you will still see it in older workbooks and training materials. Its syntax is =CONCATENATE(text1, text2, text3, ...) where each argument is a cell reference or literal text string. For example, =CONCATENATE(A1, " ", B1) joins A1 and B1 with a space, producing the same result as =A1&" "&B1.

CONCATENATE accepts up to 255 arguments, which sounds like a lot until you realize each cell counts as one argument. If you want to combine 50 cells in a row, you have to type all 50 references separated by commas. That is the function's biggest weakness, and it is why Microsoft replaced it with CONCAT in Excel 2016.

CONCATENATE is still available in newer versions for backward compatibility, and any workbook you receive with this function will continue to work indefinitely. However, if you are writing new formulas, switch to CONCAT or TEXTJOIN. They are shorter, more flexible, and easier to maintain.

Method 3: The CONCAT Function

CONCAT arrived with Excel 2016 and brought one game-changing improvement over CONCATENATE: it accepts ranges. Instead of typing =CONCATENATE(A1, A2, A3, A4, A5), you can simply write =CONCAT(A1:A5) and Excel joins everything in that range together. For longer ranges, this saves enormous amounts of typing.

The syntax is =CONCAT(text1, [text2], ...) and like CONCATENATE, each argument can be a cell reference, a range, or a literal string. The catch is that CONCAT does not add delimiters between values. If A1 contains "red", A2 contains "blue", and A3 contains "green", then =CONCAT(A1:A3) produces "redbluegreen" with no spaces or commas. To add separators, you have to insert them manually: =CONCAT(A1,", ",A2,", ",A3).

That clunkiness is exactly the gap TEXTJOIN fills.

Method 4: The TEXTJOIN Function

TEXTJOIN is the most powerful combine function in modern Excel, and once you learn it you will reach for it constantly. Its syntax is =TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) where the delimiter is the separator you want between every value, ignore_empty is TRUE or FALSE, and the rest are the cells or ranges to join.

For example, =TEXTJOIN(", ", TRUE, A1:A10) takes everything in A1 through A10, puts a comma and space between each value, and skips any blank cells in the range. If three of the ten cells are empty, the output flows smoothly without double commas or trailing punctuation.

The ability to skip blanks is what makes TEXTJOIN essential for real-world data. Imagine you have a column of phone numbers where some employees have a home phone, some have a cell, some have both, and some have neither. With TEXTJOIN set to ignore empties, you get a clean comma-separated list for each person without any of the formatting headaches that CONCATENATE or CONCAT would produce.

TEXTJOIN also accepts a different delimiter for each call, so you can use commas in one formula, semicolons in another, and pipe characters (|) in a third. The delimiter is always the first argument, which makes the function easy to read at a glance.

Method 5: Merge & Center (Visual Only)

The Merge & Center button lives on the Home ribbon in the Alignment group. Select two or more adjacent cells, click the button, and Excel joins them into a single larger cell with the top-left value displayed in the middle. There are also Merge Across (which merges cells row by row) and Merge Cells (which merges without centering).

Merging is purely a display effect. It does not combine values; it just hides them. If you merge A1, B1, and C1 that contain "John", "Smith", and "Manager", you lose "Smith" and "Manager" permanently unless you undo immediately. Worse, merged cells break sorting, filtering, and many lookup formulas. Use Merge & Center sparingly, and only for cosmetic touches like report titles.

A safer alternative is Center Across Selection. Select the cells, press Ctrl+1 to open Format Cells, go to the Alignment tab, and set Horizontal to "Center Across Selection". This produces the same visual effect as merging without actually combining the cells, so your data and formulas stay intact.

Combining Cells With Line Breaks

Sometimes you want to combine cells but have each piece appear on its own line within the resulting cell, like an address block. The trick is to insert the CHAR(10) function as your delimiter. CHAR(10) is the line-feed character that Excel recognizes as a manual line break.

For example, =A1&CHAR(10)&B1&CHAR(10)&C1 joins three cells with a line break between each. For TEXTJOIN, the formula becomes =TEXTJOIN(CHAR(10), TRUE, A1:A5). After typing the formula, you must also turn on Wrap Text for the cell (Home ribbon, Alignment group, Wrap Text button) or the line breaks will not display. Without wrap text enabled, the entire combined string runs together on one line.

Combining Cells Across Worksheets

The same combine functions work across worksheets and even across workbooks. To pull cell A1 from Sheet2 into your formula, reference it as Sheet2!A1. So =Sheet1!A1&" - "&Sheet2!A1 combines the same cell location from two different sheets with a hyphen separator.

For cross-workbook references, the syntax becomes =[Book2.xlsx]Sheet1!A1&" "&[Book3.xlsx]Sheet1!A1. Both source workbooks must be open for the reference to update live, otherwise Excel caches the last known value.

Combining Cells With Conditional Logic

You can nest IF statements inside combine formulas to control what gets included. For example, =A1&IF(B1="",""," - "&B1) joins A1 with B1 only when B1 has a value. If B1 is empty, the hyphen and space are also skipped, producing clean output without trailing separators.

This pattern is useful when building flexible labels, custom report titles, or any output where some fields might be empty. With TEXTJOIN set to ignore empties, you get the same effect with much less typing, which is yet another reason TEXTJOIN has become the modern favorite.

Common Errors When Combining Cells

Even with the right formula, things can go wrong. Here are the issues most users hit when combining cells in Excel, along with how to fix each one.

#NAME? error. This usually means you misspelled the function name or you are using TEXTJOIN or CONCAT in Excel 2013 or earlier where those functions do not exist. Double-check spelling, and if the function is correct, your Excel version is too old. Either upgrade or fall back to the ampersand operator.

#VALUE! error. TEXTJOIN throws this error if the combined output exceeds 32,767 characters. Break your input into smaller chunks or filter the data first. The same error can appear if you reference a cell containing an error like #DIV/0! or #REF!; Excel propagates the upstream error into the combine result.

Unwanted leading or trailing delimiters. If your first or last cell in the range is empty and you used CONCAT instead of TEXTJOIN, you get extra separators. Switch to TEXTJOIN with ignore_empty set to TRUE.

Numbers showing as serial dates. When combining cells that contain dates, Excel converts them to their underlying serial numbers (like 46388 for January 1, 2026). Wrap each date reference in TEXT: TEXT(A1, "mm/dd/yyyy") or whichever format you prefer.

Extra spaces from empty cells. Even with TEXTJOIN, a cell containing just a single space character is not technically empty, so it will not be skipped. Use TRIM() to clean up: =TEXTJOIN(" ", TRUE, TRIM(A1:A10)) entered as an array formula (Ctrl+Shift+Enter in older Excel, just Enter in Microsoft 365).

Combining Cells Without a Formula

If you only need a one-time combine and would rather not write a formula, Excel's Flash Fill feature can often do the job for you. Type the combined result you want in the first row by hand, then start typing the second row. Excel detects the pattern and offers to fill in the rest. Press Enter to accept the suggestion.

Flash Fill works best when the pattern is obvious. Combining "John" and "Smith" into "John Smith" is easy; combining them into "Smith, J." works most of the time too. For complex patterns or large datasets, formulas are more reliable because you can audit them later and adjust the logic if your source data changes.

Power Query is another non-formula option for combining cells, especially when you are pulling data from external sources. Inside the Power Query Editor, select two or more columns, right-click, and choose Merge Columns. Excel asks you for a separator and then collapses the selected columns into one. The new column updates automatically whenever you refresh the query.

Practical Examples From Real Spreadsheets

Theory is one thing, but combine functions really shine when you see them solving everyday problems. Below are five examples adapted from common business spreadsheets.

Building a full name from first, middle, and last columns. If column A has first names, B has middle initials (some blank), and C has last names, the formula =TEXTJOIN(" ", TRUE, A2, B2, C2) produces "John Q Smith" or just "John Smith" when the middle initial is blank. The TRUE argument makes sure you never get "John Smith" with a double space.

Assembling a mailing address. With street in A2, city in B2, state in C2, and zip in D2, use =A2&CHAR(10)&B2&", "&C2&" "&D2 and turn on Wrap Text. The result displays as a two-line address block ready to print on labels or envelopes.

Creating SKU codes from product attributes. If A2 has the product category code, B2 has the color code, and C2 has the size, then =A2&"-"&B2&"-"&C2 generates a clean SKU like "SHIRT-RED-LG". Drag the formula down to generate codes for every row in your catalog.

Joining a list of email recipients. When you have a column of email addresses and need them in a single string separated by semicolons (the format most email clients want), use =TEXTJOIN("; ", TRUE, A2:A50). Copy the result and paste it into the BCC field.

Building dynamic chart titles. Chart titles can reference a cell that combines multiple values. In a hidden helper cell, write ="Sales for "&TEXT(A1,"mmmm yyyy")&" - "&B1&" region". Then in the chart, click the title, type an equal sign in the formula bar, and reference the helper cell. The chart title updates automatically whenever A1 or B1 changes.

Putting It All Together

The right way to combine cells in Excel depends on three questions: how many cells, which version of Excel, and what does the output need to look like. For two or three cells in any Excel version, the ampersand operator gets the job done with the least typing. For long ranges in Excel 2016 or newer, TEXTJOIN is almost always the right choice because of its delimiter argument and ability to skip blanks. CONCAT is best when you genuinely want everything jammed together without separators, and CONCATENATE survives only in legacy workbooks where someone has not yet upgraded the formulas.

Merge & Center should be your last resort. It looks tidy but it breaks sorting, filtering, and copy-paste in ways that often surface only after you have spent hours building reports on top of merged cells. Center Across Selection is almost always a safer choice for visual centering, and combine formulas are always safer for joining actual data.

Once you have the methods down, the next step is practice. Build a small workbook with names, dates, and addresses, and try combining them every way you can think of. Test what happens with empty cells, with errors, with dates and numbers mixed in. The more familiar you are with how each function behaves, the faster you can pick the right one when a real spreadsheet lands on your desk.