Concat Excel Cell Range: Join Cells With Simple Formulas

With the values to join in A2:A5, enter =CONCAT(A2:A5) to combine the range into one text string; for example, Mia, Leo, and Ana in those cells produce MiaLeoAna. To add a separator or skip blank cells, use TEXTJOIN instead.

What It Means to Concatenate a Range

Concatenating means joining text from multiple cells into a single result. You might combine first and last names, assemble a mailing address, join product codes, or make a readable list from a column. The source cells remain unchanged: the formula creates a combined result in the cell where you enter it.

In Excel for Microsoft 365 on Windows, CONCAT is the direct function for joining values from a range. It processes the cells in order, moving across a row from left to right or down a column from top to bottom. It does not automatically insert spaces, commas, or other punctuation. If you need a delimiter, TEXTJOIN is usually the better choice.

Concatenation is different from adding. The plus sign performs arithmetic on numbers; it does not join text. The ampersand (&) is Excel’s text-joining operator. It can combine individual cells and text, while CONCAT and TEXTJOIN are convenient when the source is a range.

Use CONCAT for a Straight Range Join

With the names Mia, Leo, and Ana in A2:A4, enter =CONCAT(A2:A4). The result is MiaLeoAna, with no spaces or punctuation. To use the formula, select the result cell, type it in the formula bar or directly in the cell, and press Enter.

CONCAT accepts a range reference, as well as individual cells and text items. With first names in A2:A4 and matching surnames in B2:B4, for instance, you could join several cell references in a chosen order. But when combining matching fields into one name per row, it is usually clearer to create a formula for each row and fill it down, rather than flattening two entire columns into one long string.

A range can also contain numbers, dates, and other values. Excel converts those values to text for concatenation, but the displayed number format is not necessarily carried into the result. A date may appear as its underlying serial number, and a currency value may lose its currency symbol or decimal formatting. Use TEXT when the exact appearance matters.

Add Separators With TEXTJOIN

TEXTJOIN combines a delimiter, a setting for handling empty cells, and one or more text items or ranges. It is available in Excel 2019 and later, including Microsoft 365. Its arguments are the delimiter, whether to ignore empty cells, and the text or range to combine.

With Mia in A2, A3 blank, Leo in A4, and Ana in A5, enter =TEXTJOIN(", ",TRUE,A2:A5). The result is Mia, Leo, Ana: the comma and space appear between nonempty entries, and the blank cell is skipped.

The TRUE argument tells Excel to ignore empty cells. Change it to FALSE if you want the formula to retain a position for every cell. With the same layout, =TEXTJOIN(", ",FALSE,A2:A5) returns Mia, , Leo, Ana, including an empty item between the two separators. That can be useful when the position of a blank has meaning, but it often creates awkward-looking lists.

TEXTJOIN can combine more than one range or text item. For example, it can join a name range and a second range with the same delimiter, though that produces one combined list rather than pairing each first name with the surname beside it. For paired fields, build each row’s result separately.

Choose the Right Method for the Job

The best option depends on whether you need a delimiter, whether blanks should be skipped, and whether your source is a range or a few individual cells.

Use CONCAT to join a range in order without putting a separator between the values.
Use TEXTJOIN to add a consistent separator and optionally ignore empty cells. It is especially helpful for lists of variable length.
Use the ampersand (&) to join a small number of specific cells with custom text between them.
Use CONCATENATE only when maintaining an older workbook or working in an Excel version that lacks CONCAT or TEXTJOIN. It is a legacy function.

These approaches are not interchangeable in every situation. CONCAT and TEXTJOIN can take a range directly; the ampersand combines the items you explicitly write in the formula. TEXTJOIN is the most adaptable for a separated list, but CONCAT is shorter when you want a plain, uninterrupted result.

Combine Cells Into Readable Fields

For two fields in one row, the ampersand offers precise control. With a first name in A2 and a surname in B2, enter =A2&" "&B2. If A2 contains Maya and B2 contains Chen, the result is Maya Chen. The text in quotation marks is a literal space; without it, the result would be MayaChen.

With a street address in A2, a city in B2, and a postal code in C2, enter =TEXTJOIN(", ",TRUE,A2:C2). If the cells contain 14 Pine Road, Bristol, and BS1 4AA, the result is 14 Pine Road, Bristol, BS1 4AA. Ignoring empty cells lets the formula handle an optional address component without leaving a doubled comma.

For a label made from a number and a word, formatting may matter. With 1250.5 in A2 and paid in B2, enter =TEXT(A2,"$#,##0.00")&" - "&B2. The result is $1,250.50 – paid. TEXT applies the specified number format before the ampersand joins the pieces. The dollar symbol and separators in that format are examples; choose a format appropriate for the data and regional conventions in your workbook.

Handle Blanks, Spaces, and Formatting

A blank cell is not the same as a cell containing a space. CONCAT will add a space that is actually stored in a source cell, even if that space is invisible. TEXTJOIN’s ignore-empty setting is intended to skip empty values, but stray spaces can still create unexpected gaps. If a result looks wrong, inspect the source cells for spaces and formulas that return empty text.

When a formula returns a result with extra spaces, you can clean the source data or use a text-cleaning function as part of a formula. For example, with a name in A2 that may contain leading or trailing spaces and a surname in B2, enter =TRIM(A2)&" "&TRIM(B2). If A2 is ” Maya ” and B2 is ” Chen ” with extra spaces around each entry, the result is Maya Chen. TRIM removes extra spaces around text and reduces repeated internal spaces to one; it does not remove every kind of invisible character.

Concatenation returns text, even when the joined items look like a number. A combined value such as an account code may therefore no longer behave like a number in calculations. This is often desirable for identifiers, which can include leading zeros, but it matters if you plan to sort numerically or perform arithmetic on the result. Keep the original numeric fields if they will be needed for calculations.

Common Errors and Practical Limits

If Excel displays the formula itself instead of its result, check that the cell is not formatted as Text. Change the cell format to General, then edit and re-enter the formula. Also check for an apostrophe before the equals sign, which makes Excel treat the entry as text.

If the result has no separators, that is normal for CONCAT: it joins values exactly as instructed and does not add punctuation. Switch to TEXTJOIN or add literal separators with the ampersand. If a date or amount looks different from its source cell, use TEXT to specify how that value should appear in the combined string.

An error in a referenced cell can cause the concatenation formula to return an error too. Check the source range when the result shows an error rather than text. Also note that a single cell can contain at most 32,767 characters. A joined result that exceeds Excel’s cell-content limit cannot be stored as an ordinary cell value.

When you copy a formula, ordinary cell references may shift. For a formula that should always use a fixed range while being copied, use absolute references. With a fixed source range A2:A5, enter =CONCAT($A$2:$A$5). The dollar signs keep the range fixed when you copy the formula elsewhere. If each row should refer to its own neighboring cells, relative references are usually what you want.

Compatibility and Older Alternatives

CONCAT and TEXTJOIN are available in modern Excel, including Excel 2019 and Microsoft 365. If a workbook must also work in an older Excel release that does not recognize one of these functions, use the ampersand operator or the older CONCATENATE function instead. The ampersand is widely supported and is often the simplest fallback.

With values in A2, A3, and A4, enter =CONCATENATE(A2,", ",A3,", ",A4) to join those three cells with comma-space separators. If the layout has many cells, this requires listing each cell and each separator, so the formula becomes cumbersome and does not automatically skip blanks. For a handful of fixed items it can work; for a changing list, TEXTJOIN is usually easier.

The formulas described here work similarly in Excel for Windows and Excel for Mac when the relevant function is supported. Excel for the web also supports modern worksheet formulas, although some workbook features and interface details differ from desktop Excel. Function availability depends on the Excel version and update channel, so an unrecognized-function error in an older installation may mean the workbook needs a compatible alternative.

Frequently Asked Questions

How do I concatenate a whole column in Excel?
Reference the portion of the column you want to join, such as A2:A20, rather than the entire column if it contains unrelated data. Use CONCAT for a direct join or TEXTJOIN when you need a delimiter. A full-column reference may include many blank cells and can make the intended range less clear.

How do I put a comma between cells when concatenating?
Use TEXTJOIN with a comma and a space as its delimiter. Set its ignore-empty argument to TRUE if blank cells should not create empty list entries. For only a few specific cells, you can instead place a comma-space text item between cell references with the ampersand operator.

Can CONCAT combine cells from different columns?
Yes. CONCAT can take multiple cell references or ranges as arguments. Remember that it joins the supplied items in the order you give them, without adding a separator. To pair fields row by row, use a formula for each row rather than joining two whole columns into one string.

Why does my concatenated date show as a number?
Excel is converting the underlying date value to text rather than reproducing the cell’s display format. Wrap the date reference in TEXT and specify a date format, then concatenate that formatted result with the other text.

Does CONCAT remove blank cells automatically?
CONCAT adds no text for an empty cell, but it also provides no delimiter-handling options. Use TEXTJOIN when you need to choose whether empty entries should be ignored while a separator is inserted between values.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.