In Excel, + adds numbers; it does not join ordinary text strings. To combine text, use &: with text in A1 and B1, enter =A1&B1. You can also use CONCAT or TEXTJOIN when their features better fit the job.
What “string + string” means in Excel
A string is a sequence of characters, such as a name, a label, or a sentence. Excel usually calls this kind of content text. Joining two strings end to end is called concatenation. For example, combining the text in A1, “North,” with the text in B1, “Harbor,” should produce “NorthHarbor” unless you add a separator.
Excel formulas use different operators for different jobs. The plus sign is an arithmetic operator, intended for calculations such as adding two quantities. The ampersand is the text-concatenation operator. This distinction matters even when a cell looks like a string: Excel may interpret a number stored as text as a number in an arithmetic formula, while ordinary words cannot be added numerically.
So the short answer depends on what you mean by “string + string.” If you want to join words, use & or a text-joining function. If you actually want to add numeric values, use + or the SUM function.
Why the plus sign does not join ordinary text
In a formula, Excel tries to treat + as a request to perform arithmetic. With the text values “Hello” and “world,” there is no meaningful numeric sum, so Excel returns a #VALUE! error rather than joining the words. With literal text in the formula, the failing example is ="Hello"+"world".
Numeric-looking text is a special case. Excel can often convert text containing a number into a numeric value when an arithmetic operator is used. With the literal strings “1” and “2,” ="1"+"2" returns 3, not the text “12.” That result is addition after conversion, not concatenation. This behavior can make a formula seem to work while producing the wrong kind of result for a text task.
When a formula combines data from cells, the cell contents and their types matter. A cell containing a number formatted to look like text may still be numeric, while an imported value may be text even if it contains only digits. If the goal is to preserve characters and put them side by side, use a text-concatenation method rather than relying on conversion behavior.
Join text with the ampersand operator
The ampersand is usually the clearest choice for a short combination. It joins each item in order, and you can mix cell references with literal text. With “Maya” in A2 and “Nguyen” in B2, this formula returns Maya Nguyen:
=A2&" "&B2
The quoted space is a text value inserted between the two cells. Without it, the result would be MayaNguyen. You can add punctuation in the same way. With “Nguyen” in A2 and “Maya” in B2, the following produces Nguyen, Maya:
=A2&", "&B2
More than two pieces can be joined by adding more ampersands. For instance, if A2 contains a first name, B2 a middle initial, and C2 a surname, a formula can place a space between each. The operator is useful in labels as well as names: a cell value can be combined with a fixed word such as “Order ” or “Region: ”. Text in quotation marks is literal; cell references are not quoted.
Use CONCAT or TEXTJOIN for other patterns
CONCAT is a function alternative to the ampersand. With “Maya” in A2 and “Nguyen” in B2, this formula gives the same spaced name:
=CONCAT(A2," ",B2)
CONCAT is available in modern Excel versions, including Microsoft 365. It can accept multiple text items and ranges, but it does not automatically put separators between them. If you need a space or comma, include that separator as an argument.
TEXTJOIN is useful when joining a range with one repeated delimiter. With Tokyo in A2, a blank cell in B2, and Osaka in C2, this formula returns Tokyo, Osaka:
=TEXTJOIN(", ",TRUE,A2:C2)
The first argument is the delimiter, and TRUE tells Excel to ignore empty cells. Set that argument to FALSE if empty cells should still occupy a position between delimiters. TEXTJOIN is available in Microsoft 365 and supported newer Excel releases. For two or three pieces of text, & is often easier to read; for a list or a range, TEXTJOIN can be more convenient.
Choose separators, spaces, and line breaks deliberately
Excel does not insert spaces automatically. If two cells contain “Blue” and “Lake,” directly joining them produces “BlueLake.” Add a space, comma, slash, or other delimiter explicitly according to how the finished text should read. A separator is part of the formula, so changing it changes the result without changing the source cells.
For a multi-part address, for example, choose whether the output should use commas between city, region, and postal code. For identifiers, adding punctuation may be undesirable: a product code assembled from components may need to remain compact. Think about the output’s purpose before adding formatting characters, especially if another formula or system will later read the result.
A line break can also serve as a separator in a cell. The Excel function CHAR(10) represents a line-feed character in Windows worksheets. With a heading in A2 and a detail in B2, this formula joins them on separate lines:
=A2&CHAR(10)&B2
Turn on Wrap Text from Home > Wrap Text so the line break is visible within the cell. The row may need a greater height to show both lines. On Mac, CHAR(10) is also commonly used for a worksheet line break; display can depend on the cell’s wrapping and row height.
Combine text with numbers and dates
When a number is joined with text, Excel generally uses the number’s underlying value rather than the way the cell is displayed. A cell showing $1,250.50 because of currency formatting may appear as 1250.5 when concatenated. Use TEXT when the joined result must retain a chosen display format.
With a description in A2 and the numeric amount 1250.5 in B2, this formula returns Total: $1,250.50:
=A2&" "&TEXT(B2,"$#,##0.00")
The format pattern requests a dollar sign, thousands separators, and two decimal places. It changes how the number is rendered in the resulting text; the result is text, not a numeric amount suitable for arithmetic. Choose a format pattern appropriate to the data and the audience. Currency symbols and date conventions vary by region.
Dates need similar care because Excel stores dates as serial numbers. With a date in B2, use TEXT to display a readable date when joining it to words. For example, if B2 contains November 3, 2026, ="Date: "&TEXT(B2,"mmm d, yyyy") produces Date: Nov 3, 2026. If you concatenate the date without TEXT, the result may show its serial value instead of a calendar date. The source cell’s visual formatting does not necessarily carry into a concatenated text result.
Common problems and how to fix them
#VALUE!after using plus: Replace the arithmetic operator with&if the goal is to join words. A plus sign is not Excel’s text-joining operator.- Words run together: Add a quoted delimiter such as
" "or", "between the references. - Numbers lose their visible formatting: Wrap the numeric reference in TEXT and supply a format pattern, as in the currency example above.
- A date becomes an unexpected number: Use TEXT with a date pattern instead of relying on the source cell’s display format.
- Formula appears as text instead of calculating: Check whether the cell is formatted as Text, or whether the formula begins with an apostrophe. Change the cell to General, then re-enter the formula. Pressing F2 and Enter can also make Excel re-evaluate an existing entry.
- Only part of the intended value appears: Check that the references point to the expected cells and that the source values do not contain unexpected leading or trailing spaces. Concatenation preserves those spaces; it does not clean the input automatically.
For formulas with commas between function arguments, Excel’s list separator can depend on regional settings. If a formula copied from a page is rejected, check whether your Excel installation expects semicolons as separators. The examples here use the standard comma syntax.
Which method should you choose?
For ordinary joining, & is direct and easy to inspect. It makes the position of each separator obvious and works well when a formula combines a few cells and fixed words. CONCAT can be a tidy function-based alternative, especially when you already use functions to build a result. It still requires you to provide any separators you want.
TEXTJOIN is often the better fit for a list of values with a repeated delimiter, particularly when blank cells should be skipped. It can reduce a long chain of references and delimiters to one expression. However, a compact formula is not automatically a clearer one: a workbook maintained by others benefits from a method they can readily understand.
Decide whether the result needs to remain a number or date before joining it to text. Once combined with words, the result is text, so Excel cannot use that whole result directly as a number in ordinary arithmetic. Keep source values in their own cells for calculations, and create a separate combined display field when needed.
Frequently Asked Questions
Can I use + to combine two text cells in Excel?
No. Use &, CONCAT, or TEXTJOIN to join text. The plus sign performs arithmetic and normally returns #VALUE! when its operands are ordinary words.
How do I add a space between joined cells?
Put a quoted space between the references, as in =A1&" "&B1. Excel does not add spaces automatically.
What is the difference between CONCAT and TEXTJOIN?
CONCAT combines text items without inserting a delimiter for you. TEXTJOIN takes a delimiter and can optionally ignore empty cells, which makes it handy for joining a range.
Why does a joined date look like a number?
Excel stores dates as serial values. Use TEXT with a date format pattern when combining the date with other text so the output displays as a readable date.
Does concatenating cells change the original values?
No. A formula creates a result in its own cell and leaves the referenced cells unchanged. The joined result is text, even if it includes digits that look numeric.
Related
- How to Verify an Excel File Has Not Been Corrupted
- Vertical Scatter Plot in Excel: How to Create One
- Unlock an Excel Slicer: Steps, Protection, and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add Bullet Transitions to PowerPoint SlidesTo make bullet points appear one at a time, apply an entrance animation to the text box and…
- How to Remove a Section Break in Word Without Losing TextTo remove a section break in Word, show formatting marks, locate the line labeled Section Break, then place…
- Attendance Roster Template in Excel: Setup and TipsAn attendance roster template in Excel is a worksheet that lists people down the rows, meeting dates across…
- Excel Shortcut to Select the Rest of a Column DownIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+Down Arrow to extend a selection downward from the active…
- Can You Use Excel to Randomize a List? Yes, Here’s HowYes. In Excel for Microsoft 365, you can randomize a list by assigning each item a random number…
- How to Split an Excel File in Half: A Step-by-Step GuideTo split an Excel file in half, make two copies of the workbook, keep the header row in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.