Add Text Cells in Excel

What this does

Typing new text directly into an empty cell needs no formula — just click and type. Building a new value out of an existing cell PLUS extra text is the different job this answers: the & operator joins its two sides as text, silently converting numbers to text in the process, so &-ing a number stitches its digits onto a string rather than adding it arithmetically. CONCAT and TEXTJOIN do the same joining job as & but as functions — CONCAT takes a list of cells or a range, and TEXTJOIN additionally takes a delimiter and an "ignore empty" switch that neither & nor CONCAT has. CONCAT and TEXTJOIN require Excel 2019 or Microsoft 365; & has always worked in every version, including the older CONCATENATE function it effectively replaces. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “add text cells in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.

Worked example to check

Worked example: A2 contains Ada and B2 contains Lovelace. =A2&" "&B2 returns Ada Lovelace; =A2&B2 returns AdaLovelace. Fill the formula down for other records. Prefix an identifier with ="ID-"&A2; + performs arithmetic. Keep the source columns until you check the result. Copy and Paste Special > Values only when you want fixed text instead of a formula linked to the sources.

In Google Sheets

Google Sheets support for this task has not been verified. Check the function, arguments and workflow in the target product before transferring the example. Matching formula notation does not establish identical behaviour. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. For “add text cells in excel”, keep the input cells and the result visible while you check the formula in Excel. Follow the worked example and change one input at a time. The steps explain the workbook calculation; this page does not run a live calculator for that task.

Common mistakes

• Expecting &A1 to add a number arithmetically — & always joins as text, so &-ing 5 and 3 gives "53", not 8.
• Forgetting the literal space " " between pieces, producing "Mr.Alvarez" instead of "Mr. Alvarez".
• Using & across a range and getting missing separators or doubled spaces where a cell was blank — TEXTJOIN's ignore-blanks argument handles that; plain & does not.
• Leaving the joined result as a live formula referencing the original cells, then deleting or moving those cells and breaking the value — paste as values first if the source cells will not stay put.

Frequently asked questions