To join two text cells in Excel, enter =A2&B2 in another cell, replacing A2 and B2 with the cells you want to combine. To put a space between their contents, use =A2&" "&B2; the ampersand (&) joins the text, and the quoted space supplies the separator.
The simplest formula: use the ampersand
The ampersand is the most direct way to combine cell contents. It works with text, numbers, and the results of other formulas, and you can add as many pieces as you need by placing an ampersand between each one. The source cells stay unchanged; the combined result appears in the cell containing the formula.
With the text Ada in A2 and Lovelace in B2, enter =A2&B2 in C2. The result is AdaLovelace, with no gap because the formula adds no separator. If you want a space, with Ada in A2 and Lovelace in B2, enter =A2&" "&B2 in C2. The result is Ada Lovelace.
To add punctuation or other fixed text, enclose that text in straight double quotation marks. With A2 containing North and B2 containing Star, =A2&", "&B2 returns North, Star. You can also add a prefix or suffix: with an order number in A2, ="Order "&A2 returns Order followed by the value in A2. Text placed directly in a formula needs quotation marks; cell references do not.
Choose a separator that suits the data
Joining text does not automatically insert spaces, commas, line breaks, or other punctuation. Decide what the combined value should look like, then include the separator as a quoted text fragment between the cell references. Common choices include a space for names, a comma and space for a list, a hyphen for codes, or a slash for dates written as text.
- With a first name in A2 and a surname in B2, use
=A2&" "&B2for a readable full name. - With a city in A2 and a state abbreviation in B2, use
=A2&", "&B2to display a comma between them. - With a product code in A2 and a size in B2, use
=A2&"-"&B2to create a hyphenated label.
These formulas create text, not a structured address, person record, or date value. That distinction matters if you later need to sort, filter, calculate with, or split the result. For example, a date assembled from text pieces may look like a date but behave as text. Keep the original fields when you may need to analyze them separately.
Compare ampersand, CONCAT, and TEXTJOIN
For exactly two cells, the ampersand is usually easiest to read and maintain. Microsoft 365 for Windows also includes CONCAT, which combines text from multiple references or ranges. With Ada in A2 and Lovelace in B2, enter =CONCAT(A2,B2) in C2; it returns AdaLovelace. Like the ampersand formula, CONCAT does not add a separator by itself.
TEXTJOIN is useful when you want a chosen delimiter between several items and want Excel to optionally skip empty cells. With Ada in A2 and Lovelace in B2, enter =TEXTJOIN(" ",TRUE,A2,B2) in C2. The result is Ada Lovelace. The first argument is the delimiter, the second tells Excel to ignore empty cells when TRUE, and the remaining arguments are the cells or ranges to combine. TEXTJOIN is available in Microsoft 365 and supported recent Excel versions.
CONCATENATE is the older function name found in existing workbooks. It can still appear in formulas, but for a new formula the ampersand, CONCAT, or TEXTJOIN is generally clearer. Pick based on the job: use & for a short custom expression, CONCAT for a straightforward combination of many references, and TEXTJOIN when a delimiter or empty-cell handling is useful.
Handle empty cells and avoid stray spaces
If one source cell is blank, a simple formula still inserts any separator you explicitly included. With A2 containing Ada and B2 blank, =A2&" "&B2 returns Ada followed by a trailing space. That invisible character can cause problems in lookups, comparisons, and exported data even though it is hard to notice on the worksheet.
For a few cells, an IF formula can include the separator only when both cells have content. With A2 containing Ada and B2 containing Lovelace, enter =IF(B2="",A2,A2&" "&B2) in C2. The result is Ada Lovelace; if B2 is blank, the result is Ada without the extra space. This particular setup assumes A2 has the first value, so if A2 may also be blank, consider TEXTJOIN instead.
For a range where blanks should be skipped, TEXTJOIN can save a chain of IF checks. With A2 containing Ada, B2 blank, and C2 containing Lovelace, enter =TEXTJOIN(" ",TRUE,A2:C2) in D2. The result is Ada Lovelace, with one space rather than a separator for the empty cell. If you set the second argument to FALSE, empty cells are not ignored and their positions can result in repeated delimiters.
TRIM can remove extra ordinary spaces from a text result, but it should not be used blindly: it also reduces repeated spaces inside the text. If spaces are meaningful in the source, inspect the data before applying cleanup. For occasional leading or trailing spaces in source values, cleaning the source cells can be more reliable than making every joining formula more complicated.
Join numbers, dates, and formatted values
When a formula combines a number with text, Excel converts the number to text for the result. That conversion may not preserve the display format you see in the source cell. For example, a cell formatted to show a leading zero may contain the numeric value 7; concatenating it can produce 7 rather than 007. Similarly, a date may appear as a date in its cell but become a serial number in a joined string.
Use TEXT when you need to specify how a numeric value should appear inside the result. With a date in A2 and a name in B2, enter =TEXT(A2,"mmm d, yyyy")&" - "&B2 in C2. If A2 contains the date March 5, 2026, and B2 contains Ada, the result is Mar 5, 2026 – Ada. The format code controls the displayed date text; the combined result itself is text.
For a number with two decimal places, with an amount in A2, enter ="Total: "&TEXT(A2,"0.00") in B2. If A2 contains 12.5, the result is Total: 12.50. Choose a format code that matches the intended output, and remember that the resulting string is not suitable for arithmetic without converting the numeric portion back to a number.
Combine more than two cells or fill down
To join three cells with a space, add another ampersand and separator. With a first name in A2, middle name in B2, and surname in C2, enter =A2&" "&B2&" "&C2 in D2. If all three cells contain Ada, Augusta, and Lovelace respectively, the result is Ada Augusta Lovelace. If the middle name is optional, this basic formula can leave extra spaces; TEXTJOIN over A2:C2 is often more convenient when empty cells should be ignored.
After entering a formula in the first output row, copy it down for the other records. For example, when each row has a first and last name in columns A and B, the formula in C2 normally adjusts to A3 and B3 when filled into C3. These are relative references. If a cell reference must remain fixed while copying, add dollar signs to make it absolute, such as $A$2; use that only when the formula genuinely needs to keep pointing to the same cell.
If the output needs to be a fixed text value rather than a live formula, copy the results and use Home > Paste > Paste Values. This replaces formulas with their current displayed results, so later changes in the source cells will no longer update the combined values. Keep a copy of the original data if you may need to revise the combination.
Common formula problems and fixes
- The cells run together. Add the desired separator as quoted text, such as a space or comma. Excel does not insert one automatically.
- The formula displays instead of calculating. Check that the cell is not formatted as Text, and make sure the entry begins with an equals sign. If needed, change the cell format to General, then re-enter the formula.
- A leading apostrophe appears or the result looks unchanged. The cell may be treating the entry as text. Remove an accidental leading apostrophe and confirm calculation is enabled.
- There is an unexpected number or date value. Use TEXT with an appropriate format code for values that must retain a specific display when converted to text.
- A formula returns an error after copying. Check that references still point to the intended cells and that no row or column was deleted. Relative references move when copied.
In some regional settings, Excel uses semicolons rather than commas to separate function arguments. The formulas shown here use commas, as in the standard English-language syntax; if Excel rejects a function formula, your regional list-separator setting may require semicolons instead. The ampersand examples do not rely on function argument separators.
Frequently Asked Questions
What is the formula to join two cells with a space in Excel? If the two values are in A2 and B2, enter =A2&" "&B2 in another cell. The quoted space is the separator, so the result has one space between the values.
Can I combine two cells without a formula? You can copy and paste text manually, but it will not update when the source cells change. A formula such as =A2&B2 creates a live result that recalculates when either referenced cell changes.
Does CONCAT add a space between cells? No. CONCAT joins the supplied text without adding a delimiter. If the values are in A2 and B2 and you want a space, use =CONCAT(A2," ",B2) or use the ampersand formula with a quoted space.
How do I join cells while ignoring blanks? With values in A2:C2 and spaces as separators, use =TEXTJOIN(" ",TRUE,A2:C2). TRUE tells TEXTJOIN to ignore empty cells, which avoids separators for blank entries.
Will the joined result change if I edit a source cell? Yes, if the result is still a formula and calculation is set to Automatic. If you paste the result as a value, it becomes fixed text and no longer updates from the source cells.