To concat Excel columns—that is, join values from separate cells into one—use the ampersand operator. With first names in A2 and last names in B2, enter =A2&" "&B2 in C2 to return a full name with a space between the parts. You can also use CONCAT or TEXTJOIN, depending on whether you need a delimiter and how many cells you are combining.
What concatenating columns means
Concatenation joins text or values together; it does not combine the cells themselves. If A2 contains Rina and B2 contains Patel, a formula can display Rina Patel in C2 while leaving the original cells unchanged. This is useful for names, addresses, product codes, labels, and other fields assembled from separate pieces of data.
People sometimes use “concatenate columns” to mean different things. Joining A2 and B2 side by side in one result is concatenation. Putting the contents of two columns into one long vertical list is a different operation, and merging cells with Excel’s Merge & Center command is different again. A formula is usually the right choice when the result should update if its source cells change.
Use the ampersand for a simple join
The ampersand (&) is the most direct way to join a few values. It works in Microsoft 365 for Windows and is also supported by other Excel versions. Text you type directly into the formula must go inside straight double quotation marks; cell references do not need quotation marks.
With a first name in A2 and a last name in B2, use =A2&" "&B2. For the example values Rina and Patel, the result is Rina Patel. The quoted space is essential: without it, =A2&B2 would return RinaPatel.
You can include punctuation or labels in the same way. With a city in A2 and a state abbreviation in B2, use =A2&", "&B2 to create a result such as Seattle, WA. With a product code in A2 and a size in B2, =A2&" - "&B2 adds a spaced hyphen. The punctuation is part of the text in quotation marks.
After entering a formula in the first result row, fill it down to apply it to other rows. Select the formula cell and drag its fill handle, or select the destination cells and use Home > Fill > Down. Excel adjusts relative references as the formula is copied: a formula using A2 and B2 becomes one using A3 and B3 in the next row.
Choose between CONCAT, TEXTJOIN, and &
All three approaches can combine text, but they serve slightly different needs. The ampersand is clear for a small number of cells. CONCAT is a function-based alternative that joins text without adding a delimiter automatically. TEXTJOIN is especially handy when a delimiter should appear between many values, and it can skip empty cells.
- &: A familiar operator for two or a few values, with complete control over where spaces and punctuation go.
- CONCAT: A function for joining text arguments or a range, but it does not insert separators for you.
- TEXTJOIN: A function that takes a delimiter, a choice about whether to ignore empty cells, and the text or range to combine.
With a first name in A2 and a last name in B2, =CONCAT(A2," ",B2) returns Rina Patel when those cells contain Rina and Patel. This is functionally similar to the ampersand example. CONCAT is available in Microsoft 365; older Excel installations may instead have the legacy CONCATENATE function. The ampersand remains a widely compatible option.
With words in A2, B2, and C2, =TEXTJOIN(" ",TRUE,A2:C2) joins the three cells with spaces and ignores blanks. If A2 is Rina, B2 is Patel, and C2 is empty, the result is Rina Patel, not Rina Patel with an extra trailing space. TEXTJOIN is available in Microsoft 365 and newer Excel releases, but may not be present in older perpetual versions.
Join several columns with a delimiter
A delimiter is the text placed between joined values: a space, comma, slash, hyphen, or another character. For multiple fields, a delimiter-based formula is often easier to read and maintain than repeating ampersands between every cell.
With a street address in A2, city in B2, and postal code in C2, the formula =TEXTJOIN(", ",TRUE,A2:C2) places a comma and space between nonempty entries. For example, 10 Oak Street, Salem, 97301 becomes one string. If an optional address field is blank, the TRUE argument tells TEXTJOIN to skip it rather than leaving an empty slot between delimiters.
The first TEXTJOIN argument is the delimiter. The second is either TRUE or FALSE: TRUE ignores empty cells, while FALSE includes them. The remaining argument or arguments identify the text to join. A range such as A2:C2 is convenient when the cells are next to one another; separate references can be supplied when they are not.
Be aware that ignoring blanks is not the same as ignoring cells containing a formula that returns an empty string. In many cases, TEXTJOIN treats an empty-string result like an empty value, but formulas and data-cleanup needs can make the distinction matter. Check the result when the source range contains formulas or imported data.
Keep dates, numbers, and currency readable
When Excel joins a number or date directly to text, the displayed result may not preserve the cell’s number format. For example, a date stored as a serial number may appear as a number, and a currency value may lose its currency symbol or decimal places. The cell’s visual formatting does not necessarily travel with its value into a concatenated string.
Use TEXT to specify how a value should appear before joining it. With a date in A2 and an event name in B2, =TEXT(A2,"mmm d, yyyy")&" - "&B2 formats the date as a short month, day, and year, followed by a hyphen and the event name. If A2 contains January 5, 2026 and B2 contains Inventory, the result is Jan 5, 2026 – Inventory.
With an amount in A2 and a description in B2, =TEXT(A2,"$#,##0.00")&" - "&B2 formats a value of 1250 as $1,250.00 – Supplies. The format pattern controls the displayed string; it does not change the underlying number in A2. Choose a pattern that suits the data and the conventions used by your workbook.
Once a date or number has been converted to text as part of a concatenated result, the combined result is text, not a date or number that Excel can directly sort or calculate as its original type. Keep the source values in separate columns if later calculations are important.
Handle missing values and extra spaces
Empty cells can create awkward results with the ampersand. If A2 is blank and B2 contains Patel, =A2&" "&B2 begins with a space. If leading or trailing spaces are a concern, use TEXTJOIN with a space delimiter and the empty-cell option set to TRUE, or add a condition for the fields that must be present.
With a first name in A2 and a last name in B2, =IF(A2="","",A2&" "&B2) returns a blank result if A2 is blank; if A2 contains Rina and B2 contains Patel, it returns Rina Patel. This condition does not check whether B2 is blank, so decide which missing-field behavior fits your data. For more complicated rules, nested IF functions or TEXTJOIN may be more suitable.
Imported text can also contain unwanted spaces at the beginning or end of a cell. TRIM can help clean ordinary extra spaces. With source text in A2 and B2, =TRIM(A2)&" "&TRIM(B2) removes leading and trailing spaces from each value and reduces repeated internal spaces to single spaces. TRIM does not remove every kind of invisible character, so data copied from websites or other systems may need additional cleanup.
Copy the formula down and decide what to do with results
Enter the formula in the first row of the output column, then fill it down alongside the source data. If the source is formatted as an Excel table, entering a formula in a table column typically fills that calculated column for its rows and extends it when new rows are added. Give the output column a clear heading, such as Full Name or Mailing Address, so the combined field is easy to identify.
Formula results remain linked to the source cells. Changing a source value updates the concatenated result, which is useful when the source data is still being edited. If you need a fixed snapshot for export or handoff, copy the result cells and use Paste Special > Values. This replaces formulas with their current displayed results; retain a copy of the workbook first if you may need the live formulas later.
Do not use Merge & Center as a substitute for concatenation. Merging cells changes the worksheet layout and can discard contents in all but the upper-left cell of the merged range. Concatenation creates a new value while preserving the original source cells, making it safer for lists that need sorting, filtering, or further processing.
Common formula problems
- No space between words: Add a quoted space, such as
&" "&, between the cell references. - Unexpected number or date display: Wrap the value in TEXT and provide an appropriate number-format pattern.
- Extra punctuation around blanks: Use TEXTJOIN with TRUE to skip empty cells, or write a condition for required fields.
- Formula appears as text: Check that the cell is not formatted as Text, and that the formula begins with an equals sign. Change the cell to General and re-enter the formula if needed.
- Formula is not updating: Check Formulas > Calculation Options and confirm that calculation is set to Automatic if you expect changes to recalculate immediately.
A formula can also return a result that looks right but is not the data type you expect. A concatenated number is text, so a total or numeric sort may not behave like it would on the original number. Use the original source columns for calculations, and use the joined column for display or export where a single text field is required.
Frequently Asked Questions
How do I concatenate two columns in Excel with a space? With the values in A2 and B2, enter =A2&" "&B2 in the result cell. Fill the formula down to combine the corresponding cells in each row.
Can I concatenate columns without a formula? You can use Flash Fill for pattern-based results: type an example of the desired combined value in the first output cell, then choose Data > Flash Fill or press Ctrl+E on Windows. Flash Fill produces values rather than formulas, so the output does not automatically update when its source cells change. On Mac, use the Data tab’s Flash Fill command when it is available in your Excel version.
What is the difference between CONCAT and CONCATENATE? Both join text, but CONCAT is the newer function and can work with ranges, while CONCATENATE is the older function retained for compatibility. Neither automatically inserts spaces or punctuation. Add those as text arguments or use TEXTJOIN when you want a delimiter.
How do I combine columns and skip blank cells? Use TEXTJOIN with TRUE as its empty-cell argument. With entries in A2:C2 and a space between items, =TEXTJOIN(" ",TRUE,A2:C2) joins the nonempty cells without adding a separator for an empty cell.
Does concatenating cells merge them? No. A concatenation formula makes a new text result and leaves each source cell separate. Excel’s Merge & Center changes the cell layout and is not a reliable way to combine the contents of multiple filled cells.
Related
- Excel Accounting Format: Show Negative Numbers in Brackets
- Excel Data Analysis: How to Build a Useful Model
- Remove a Data Model from Excel: Steps and Effects
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- XLOOKUP Partial Match: Wildcard Examples in ExcelFor a contains-style partial match, put the text to find in E2 and use =XLOOKUP("*"&E2&"*",A2:A7,B2:B7,"No match",2). The final…
- Excel Date Format Formulas: TEXT, DATEVALUE, and MoreTo display a date as text with an Excel formula, use TEXT; with a date in A2, =TEXT(A2,"mmmm…
- XLOOKUP Formula: Real Examples in ExcelThe basic XLOOKUP formula is =XLOOKUP(E2,A2:A6,B2:B6): it looks for the value in E2 within A2:A6 and returns the…
- Excel Column Minus Column Formula: Examples and FixesIf your values are in A2:A100 and B2:B100, enter =A2-B2 in C2 to subtract the value in column…
- Excel FIND Function: How to Find Text Within a StringIn Excel, use FIND to locate text inside a string and return the position where it begins. For…
- CONCAT in Excel: Join Text and NumbersYes. Excel’s CONCAT function can join numbers with text or other values, but it does not preserve a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.