To join text from two Excel columns on the same row, enter =A2&" "&B2 in a third column and fill the formula down. This combines the contents of A2 and B2 with one space between them; change the quoted separator to a hyphen, comma, or other text as needed.
What joining two columns means
Most often, “join text from two columns” means combining the values in each row while keeping the rows separate. For example, a first name in column A and a last name in column B can become a full name in column C. The formula in C2 refers to A2 and B2; when copied to C3, Excel adjusts those references to A3 and B3.
This is different from combining every value in both columns into one long cell. That can be useful for a list or a sentence, but it needs a different formula. Decide which result you want before choosing a method: one combined result per row, or one result containing many cells.
In Microsoft Excel for Microsoft 365 on Windows, you can type a formula directly into a cell. The examples below assume the source values begin in row 2 and the result belongs in column C. If your data starts elsewhere, replace the cell references accordingly.
Use the ampersand for a simple row-by-row join
The ampersand (&) is the most direct way to join cell contents. With a first name in A2 and a last name in B2, enter this in C2:
With the first name Ada in A2 and the last name Lovelace in B2, use =A2&" "&B2. The result is Ada Lovelace.
The quoted space is literal text: it tells Excel to put a space between the two cell values. Without it, =A2&B2 would return AdaLovelace. You can put other literal text between the references. For example, with A2 containing North and B2 containing Shore, =A2&", "&B2 returns North, Shore.
Once the formula works in C2, copy it down the result column. You can drag the fill handle, the small square at the bottom-right corner of the selected cell, or select the target range and use the fill-down command. On Windows, Ctrl+D fills the selected cells with the formula or value from the top cell; on Mac, Control+D is the corresponding fill-down shortcut in Excel. Check the last few rows after filling to make sure the source data and output ranges line up.
Choose a separator that fits the result
The separator is part of the formula, not a property of the source cells. Use a single space for names, a comma and space for city-and-region text, or a label such as a slash or dash when that is clearer. The formula should include the punctuation inside straight double quotation marks.
- For a first and last name, use a space:
=A2&" "&B2. - For a city and state, use a comma and space:
=A2&", "&B2. - For a product code and size, use a hyphen:
=A2&"-"&B2.
Think about whether the separator should appear when one of the cells is empty. A basic ampersand formula still adds the separator, which can leave a leading or trailing space, comma, or dash. If empty cells are possible, use a method that handles them deliberately rather than relying on the separator to disappear.
Use CONCAT or TEXTJOIN when they suit the job
CONCAT is a function-based alternative to the ampersand. It combines text values but does not add a separator automatically. With the first name in A2 and the last name in B2, use =CONCAT(A2," ",B2); the result is Ada Lovelace. The space is a separate argument, just as it is literal text in the ampersand formula.
TEXTJOIN is useful when you want to specify a separator and decide whether empty cells should be ignored. With Ada in A2 and Lovelace in B2, use =TEXTJOIN(" ",TRUE,A2,B2); the result is Ada Lovelace. The first argument is the delimiter, and TRUE tells Excel to ignore empty cells. TEXTJOIN is available in Microsoft 365 and Excel 2019 or later.
TEXTJOIN can also combine more than two cells. With words in A2, B2, and C2, use =TEXTJOIN(" ",TRUE,A2:C2) to join the row with spaces and skip empty cells. This is often easier to maintain than adding a separate ampersand and separator for every cell. CONCAT is also convenient for multiple values, but it does not provide TEXTJOIN’s delimiter and ignore-empty options.
Handle blanks without stray punctuation
Suppose A2 contains a first name but B2 is blank. A basic formula such as =A2&" "&B2 returns the name followed by a space. The extra space may be difficult to see in the cell, but it can affect later matching, sorting, or text exports. TEXTJOIN is a straightforward fix when the separator should be omitted for an empty cell: with the same two-cell layout, =TEXTJOIN(" ",TRUE,A2,B2) returns just the nonblank value.
There is an important distinction between an empty cell and a value that looks blank. A formula returning an empty string, such as ="", is treated as empty by TEXTJOIN when its ignore-empty argument is TRUE. A cell containing a space is not empty, so TEXTJOIN will include it. A numeric zero is also a value, not an empty cell, and is not skipped merely because it may be hidden by a number format.
If the output should remain empty when both source cells are empty, add a condition. With values in A2 and B2, use =IF(AND(A2="",B2=""),"",TEXTJOIN(" ",TRUE,A2,B2)). If both cells are empty, this returns an empty string; otherwise, it joins the nonempty values with a space. This can keep a results column from filling with separators or apparent blank outputs in unused rows.
For messy source text, TRIM can remove ordinary leading and trailing spaces and reduce repeated spaces between words. With text in A2 and B2, use =TRIM(A2&" "&B2). It can help when imported data contains extra regular spaces, but it does not remove every kind of invisible character; nonbreaking spaces copied from web pages may need separate cleanup.
Preserve number and date formats
When a formula joins text with a number or date, Excel combines the underlying value rather than automatically reproducing the cell’s displayed format. A date stored as a serial number, for example, might appear as a number in the joined result. Use the TEXT function to specify how the value should look in the combined text.
With a label in A2 and a valid date in B2 representing January 15, 2026, use =A2&" "&TEXT(B2,"mmmm d, yyyy"). If A2 contains “Due,” the result is Due January 15, 2026. The format code controls the date’s appearance in the result; it does not change the date stored in B2.
For a price, with an item name in A2 and a numeric amount of 1250.5 in B2, use =A2&" - "&TEXT(B2,"$#,##0.00"). If A2 contains “Desk,” the result is Desk - $1,250.50 in a setup using that currency and number convention. Format codes and separators can display differently with regional settings, so adapt the currency symbol and decimal conventions to the workbook’s intended audience.
After a number or date has been converted into text as part of a joined result, the combined cell is text. It will not behave like a standalone numeric amount in calculations. Keep the original numeric or date columns if you may need to sort by them, calculate with them, or apply numeric formatting later.
Fill the formula down and check the results
For a short list, enter the formula in the first output row and copy it down. Excel adjusts ordinary relative references automatically, so a formula pointing to A2 and B2 becomes one pointing to A3 and B3 in the next row. If you see the same name repeated, check whether the formula was copied as a value or whether a reference was locked with dollar signs, such as $A$2, when you intended it to change by row.
If the source data is in an Excel table, add a formula in the first cell of a new table column. Excel generally fills that calculated column with the corresponding row formula and extends it as table rows are added. Table formulas can use readable structured references instead of cell addresses, but the basic principle is identical: combine the values from the current row and place the result in the output column.
For a large worksheet, inspect a few results at the top, middle, and bottom. Confirm that the source rows correspond, the separator is right, and blank rows do not produce unwanted punctuation. If the result will be sent to another system, check its rules for spaces, punctuation, and text length as well.
Combine many cells into one result
If you mean joining all the values in a range into one cell, use TEXTJOIN with a range rather than copying a two-cell formula down. With values in A2:A10 and a comma-space separator, use =TEXTJOIN(", ",TRUE,A2:A10). It returns one comma-separated string and skips empty cells. This is useful for producing a compact list, but it puts all those values into a single cell rather than creating one result for every row.
Excel cells have a maximum text length of 32,767 characters. A large TEXTJOIN result can reach that limit, and a very long combined value may also be difficult to read or use in another system. For bigger datasets, keeping records in separate rows is usually easier to filter, sort, validate, and analyze than storing an entire list in one cell.
Common problems and how to fix them
- No space between words: Add a quoted space between the cell references, as in
=A2&" "&B2. Excel does not insert spaces on its own. - Unexpected numbers or dates: Wrap the numeric or date cell in TEXT and provide a suitable format code.
- Extra spaces or separators: Use TEXTJOIN with its ignore-empty argument set to TRUE, or apply TRIM where ordinary extra spaces are the issue.
- The formula appears as text: Check whether the cell is formatted as Text or whether an apostrophe appears before the equals sign. Change the cell format to General, then re-enter the formula.
- The formula does not update: Check that workbook calculation is set to automatic and that the source cells contain the expected values.
A related misconception is that joining cells merges them. It does not: a formula creates a text result in a cell while leaving the source cells unchanged. This is usually safer than deleting or overwriting the original data. If you need a fixed text result rather than a live formula, copy the results and use Paste Special > Values to replace the formulas with their current displayed values. Keep a copy of the source data if it may be needed later.
Frequently Asked Questions
Can I join two columns without a space? Yes. With the values in A2 and B2, use =A2&B2. Add a quoted separator only when you want one, such as =A2&"-"&B2 for a hyphen.
What is the difference between CONCAT and TEXTJOIN? CONCAT combines the values you give it but does not add a delimiter automatically. TEXTJOIN accepts a delimiter and can ignore empty cells, which makes it more convenient for lists or rows where some values may be missing.
Can I combine first and last names while skipping a blank cell? Yes. With the names in A2 and B2, use =TEXTJOIN(" ",TRUE,A2,B2). If one cell is empty, Excel joins the other value without adding a separator for the missing one.
Can I join two columns and keep the formula result as plain text? Copy the formula results, then use Paste Special > Values. The resulting cells contain the current text rather than formulas, so they will not change when the source cells change.
Does joining text change the original cells? No. The formula writes a combined result in the cell where you enter it. The source values stay in their original columns unless you deliberately edit or replace them.
Related
- Excel Insert Row Below a Selected Row: Quick Steps
- Excel: Import Multiple CSV Files Into One Worksheet
- Excel Insert Blank Row Every Other Row: Methods That Work
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel FILTER Formula for Multiple CriteriaTo filter rows in Excel by multiple criteria, use FILTER with a condition for each test: multiply the…
- Excel Formula for Rounding Numbers: ROUND and MoreUse Excel’s ROUND function to round a number to a chosen number of decimal places: with the value…
- Excel Filters: How to Sort and Show the Rows You NeedTo filter data in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data…
- Excel Goal Seek Formula Alternatives That WorkExcel does not have a worksheet function called GOALSEEK; Goal Seek is a What-If Analysis command. The formula…
- Excel Formula for Weeks Between Two Dates: Full WeeksTo calculate weeks between two dates in Excel, subtract the start date from the end date and divide…
- Excel TRIM LEN Formula: Count Characters After CleanupTo count the characters in text after removing extra spaces, put the text in A2 and enter =LEN(TRIM(A2))…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.