To combine text from cells in Excel, use =CONCATENATE(A2," ",B2); if A2 contains Grace and B2 contains Hopper, the result is Grace Hopper. The formula joins the cell contents in the order you give them, while the quoted space supplies the separator. In Microsoft 365, you can also use the newer CONCAT function or the & operator.
What CONCATENATE Does
CONCATENATE combines two or more text values into one text string. Those values can come from cell references, typed text, or other formulas. It is useful for assembling full names, addresses, labels, product descriptions, and other text made from separate spreadsheet columns.
The function does not insert spaces, commas, or other punctuation automatically. If you join A2 and B2 without a separator, their contents run together. Include the separator as a quoted text argument wherever it belongs. The original cells are not changed; the combined result appears in the cell containing your formula.
CONCATENATE remains available in Excel, including Microsoft 365, and can be helpful when working with older workbooks or instructions that use it. Microsoft also offers CONCAT, a newer function with a similar purpose. For a simple join, the & operator is another straightforward option.
CONCATENATE Syntax and Arguments
The syntax is =CONCATENATE(text1, [text2], ...). The first value is required; later values are optional. Put cell references or expressions directly into the argument list, and put any literal text, such as a space or comma, inside straight double quotation marks. In a standard English-language Excel installation, separate arguments with commas.
For example, the formula below has three arguments: A2, a space, and B2. Excel evaluates each one and joins the resulting text in sequence.
With a first name in A2 and a surname in B2—for example, Grace and Hopper—enter =CONCATENATE(A2," ",B2). The result is Grace Hopper.
CONCATENATE accepts up to 255 text arguments. You do not need to supply one argument for every character: a whole cell value is a single argument, and a quoted separator is another. In regional settings that use a different list separator, Excel may display semicolons instead of commas in formulas; follow the separator shown by your own Excel installation if a comma-separated formula is rejected.
How to Enter the Formula
- Select the cell where you want the combined text to appear.
- Type an equals sign and the function name, then add the opening parenthesis:
=CONCATENATE(. - Select the first source cell, type a comma, enter any quoted separator, and continue with the next cell reference.
- Type the closing parenthesis and press Enter. Check the result, then copy the formula down if you want to combine other rows.
You can type a formula directly into a cell or into the formula bar. To fill it down, select the formula cell and drag its fill handle, the small square at the lower-right corner of the selection. Excel adjusts relative references as the formula moves: a reference to A2 becomes A3 in the next row. On Windows, Ctrl+C and Ctrl+V copy and paste a formula; on Mac, use Command+C and Command+V. If you need the combined text to stay fixed rather than update with its source cells, copy the results and use Paste Special > Values from the Home tab.
Add Spaces, Commas, and Other Separators
A separator is ordinary text placed between cell references. It can be a space, punctuation mark, line of text, or even a combination. Choose one that makes the final value readable and consistent with the data you are creating.
- For a full name, put a space between the first and last names.
- For a location, use a comma and a space between the city and region.
- For a code, use a hyphen or slash only if that matches the format you need.
With a city in A2, a region in B2, and a location type in C2—for example, North, Shore, and Clinic—enter =CONCATENATE(A2,", ",B2,", ",C2). The result is North, Shore, Clinic. Each comma and following space is included as a quoted argument, so the formula controls exactly where punctuation appears.
A common mistake is expecting Excel to add spaces based on the formatting or visual spacing of the source cells. It will not: a cell’s alignment, column width, and indentation are not part of its value. If a gap should appear in the result, include a literal space such as " " in the formula.
Joining Numbers and Dates
CONCATENATE can join numeric values with text, but the result is text, not a number that Excel can use directly in arithmetic. Also, the displayed number format in a source cell is not necessarily carried into the combined string. A date, for example, is stored as a serial number, so joining it without formatting can produce an unexpected-looking number.
With the label in A2 and an actual Excel date in B2—for example, July 4, 2026—enter =CONCATENATE(A2," ",TEXT(B2,"mm/dd/yyyy")). If A2 contains Invoice date:, the result is Invoice date: 07/04/2026. The TEXT function converts the date to the specified display format before CONCATENATE joins it. Choose a date pattern appropriate for your audience; formats such as day/month/year can be interpreted differently across regions.
Similarly, use TEXT when a number needs a particular number of decimal places, a percentage style, or leading zeros in the combined output. For instance, a code with leading zeros may need to be stored or formatted as text, because numeric cells ordinarily do not preserve zeros at the beginning. Decide whether the result is for display or later calculation: once a value is joined with text, Excel treats the combined result as text.
Handling Blank Cells
CONCATENATE includes the contents of each referenced cell, including an empty string for a truly blank cell. A fixed separator is still added, however. If the middle cell in a three-part name is blank, a formula that always inserts spaces on both sides of that cell can leave an extra space in the result.
For a simple case with a required value in A2 and an optional value in B2, you can add the second value only when it is not blank.
With a required order label in A2 and an optional note in B2, enter =CONCATENATE(A2,IF(B2<>""," "&B2,"")). If A2 contains Order 104 and B2 is blank, the result is Order 104; if B2 contains Rush, the result is Order 104 Rush.
For longer lists where blank cells should be skipped, TEXTJOIN is often more convenient than adding an IF condition for every possible cell. It lets you specify a delimiter and tell Excel whether to ignore empty cells. That is especially helpful for assembling an address from columns that are not always filled in.
CONCATENATE, CONCAT, TEXTJOIN, or the & Operator?
These approaches all join text, but they suit different situations. CONCATENATE is recognizable and works in older workbooks. CONCAT is a newer function designed to replace it for many everyday joins. The & operator is compact for a few values, while TEXTJOIN handles a repeated separator and empty cells efficiently.
- Use CONCATENATE when an existing workbook or shared formula already uses it, or when you want to learn its familiar argument-by-argument pattern.
- Use CONCAT for a similar function-based formula in current Excel. It can also work with ranges, which can make larger joins shorter.
- Use & for a small number of pieces when the formula is easier to read as a direct expression.
- Use TEXTJOIN when you need the same delimiter between many values and want Excel to ignore blank cells.
For example, with a first name in A2 and a surname in B2, =A2&" "&B2 also returns Grace Hopper. With values red, blank, and blue in A2:C2, =TEXTJOIN(", ",TRUE,A2:C2) returns red, blue, skipping the empty cell. If these functions are unavailable in an older Excel release, CONCATENATE or & may be a more compatible choice. Choose based on the workbook’s version requirements and how easily another person can understand the formula.
Common Problems and Fixes
If a formula appears as plain text instead of returning a result, check whether the cell is formatted as Text or whether the formula begins with an apostrophe. Change the cell format to General, edit the formula, and press Enter again. A cell formatted as Text can cause Excel to display the characters you typed rather than evaluate them.
If the result has no spaces, check that the separator is present as a quoted argument. If it has doubled spaces or stray commas, inspect the formula for separators that are added even when a source cell is empty. For a date or number that looks wrong, use TEXT to specify how that value should appear before joining it.
A #NAME? error can mean the function name was mistyped, or that Excel cannot parse the formula as entered. Verify the spelling, quotation marks, parentheses, and argument separators. In some language or regional settings, function names and formula separators may differ from examples written for English Excel. Do not replace straight quotation marks with decorative “curly” quotation marks when typing a formula.
Finally, remember that a combined text value is not a substitute for separate, structured data when you still need to sort, filter, or calculate using its individual parts. Keep the original columns when possible, and create a combined column for presentation or export. That makes later corrections and analysis much easier.
Frequently Asked Questions
Is CONCATENATE still available in Excel?
Yes. CONCATENATE remains available in Microsoft 365 and is found in older Excel workbooks as well. CONCAT is the newer alternative for many uses, but existing CONCATENATE formulas do not need to be rewritten just because the newer function exists.
How do I combine two cells with a space between them?
With the values in A2 and B2, enter =CONCATENATE(A2," ",B2). The quoted space is an argument, so the returned text has a visible gap between the two cell values.
Can CONCATENATE combine a whole range?
It can join values, but CONCATENATE is structured around individual arguments and can become cumbersome for a long range. CONCAT can accept ranges in supported versions, and TEXTJOIN is often a better fit when you also want a delimiter or need to skip blanks.
Why did my date turn into a number?
Excel stores dates as serial values, and joining a cell reference does not necessarily preserve the date’s display format. Wrap the date reference in TEXT with a format such as "mm/dd/yyyy" before combining it with other text.
Does CONCATENATE change the original cells?
No. It returns a combined value in the formula cell and leaves its source cells unchanged. If you later remove the source values, the formula may no longer return the same result; copy the output and paste values if you need a fixed text result.
Related
- Unmerge Excel Cells Without Losing Data
- Unmerge Cells in Excel on iPad: Steps, Limits, and Fixes
- Ungroup Shortcut in Excel: Keys and Menu Options
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Filter in Excel Using Keyboard Shortcuts and MenusTo filter a list in Excel for Microsoft 365 on Windows, select a cell in the data, press…
- How to Filter Multiple Dates in Excel by Range or ListTo filter multiple dates in Excel, turn on the column filters, open the arrow on your date column,…
- Sort a List in Excel: Steps and Custom SortsTo sort a list in Excel, click a cell in the list, then choose Data > Sort A…
- NPV Formula in Excel: How to Use ItThe NPV (Net Present Value) formula in Excel is =NPV(rate, value1, [value2], ...), where rate is the discount…
- How to Filter Dates in Excel by Month, Year, or RangeTo filter dates in Excel, select a cell in your data, choose Data > Filter, open the arrow…
- Monthly Loan Payment Formula in ExcelTo calculate a fixed monthly loan payment in Excel, use PMT. With the loan principal in B1, the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.