Combine Text From Two Cells
To combine the text from two cells, use =A2&" "&B2 — not Merge & Center, which merges the cells themselves and keeps only the top-left value. Merging is a formatting operation on cells; joining is a formula operation on their contents, and the two get confused constantly because Excel puts Merge & Center on the Home tab where people look first. For a whole row or column of values, =TEXTJOIN(" ", TRUE, A2:D2) beats a chain of ampersands because it accepts a range and skips blanks. Once the joined text is right, copy it and use Paste Special > Values before deleting the original columns, or every joined cell collapses to #REF!.
The formula
=A2&" "&B2 first and last name, with a space between them
=A2&", "&B2 any literal text — commas, dashes, labels — goes inside the quotes
=TEXTJOIN(" ", TRUE, A2:D2) join a whole range at once and skip any blank cells
=TRIM(A2&" "&B2) guards against a trailing space when B2 turns out to be emptyA worked example
A2 holds "Marcus", B2 holds "Whitfield", and you have already tried Merge & Center on A2:B2 and lost the surname.
=A2&" "&B2 in C2, then copy C2 and Paste Special > Values over itself
"Marcus Whitfield" sits in C2 as static text, and A2:B2 can now be deleted safely. Skip the Paste Special step and deleting those columns leaves #REF! behind, because the formula still points at cells that no longer exist. Merge & Center could never have produced this: it discards "Whitfield" and leaves one wide cell containing "Marcus" alone.
Which one do I need?
| If you want to… | Use |
|---|---|
| You want the contents of two cells to end up in one cell | =A2&" "&B2 — put whatever should sit between them inside the quotes |
| You clicked Merge & Center and a value disappeared | Undo immediately. Merging keeps only the upper-left value and discards the rest; it is a layout tool, not a way to join text |
| Joining a whole column, or a range with gaps in it | =TEXTJOIN(delimiter, TRUE, range) — the TRUE argument is what skips the blanks |
| You need the syntax, arguments and version differences of the join functions themselves | That is the function reference, not this task page — CONCATENATE, CONCAT and TEXTJOIN compared side by side |
| Joining two full columns down thousands of rows | Same formula, filled down — or a single spilled formula in Excel 365 |
| The joined cell shows something like 46022 where a date should be | =A2&" "&TEXT(B2,"dd mmm yyyy") — joining reads the stored serial number unless TEXT formats it first |
| You need to pull a combined value back apart again | That is the reverse operation, with its own tools and trade-offs |
Frequently asked questions
Does merging cells in Excel combine their text?
No. Merge & Center combines the cells into one larger cell and keeps only the value in the upper-left one, discarding everything else — Excel even warns you before it does it. To combine the text you need a formula such as =A2&" "&B2, which leaves the original cells untouched.
How do I combine first and last name in Excel?
Put =A2&" "&B2 in an empty column beside them, where A2 is the first name and B2 the surname, and fill it down. The space inside the quotes is what separates the two names; without it you get "MarcusWhitfield".
Why do I get #REF! after deleting the original columns?
The joined cells still hold a live formula pointing at those columns, so deleting them breaks the reference. Copy the joined column and use Paste Special > Values over itself first — that converts the formulas into plain text, after which the source columns are safe to remove.
Can I combine cells without using a formula?
Yes. Type the combined result for the first row into the next column, then press Ctrl+E and Flash Fill completes the rest by pattern. The output is static text rather than a live formula, so it will not update if the source cells change later.
New guides and tools, once a month
DE + EN · double opt-in · no spam