With text in A1 and B1, join the contents directly with =A1&B1; to put a space between them, use =A1&" "&B1. Enter the formula in a third cell and press Enter. The ampersand method works in Microsoft Excel for Microsoft 365 on Windows and is also available in Excel for Mac and Excel for the web.
How combining text works
Combining text is often called concatenation. Excel takes the contents of two or more cells and joins them into one result. The source cells stay unchanged: a formula in C1 can display a combined result while A1 and B1 retain their original values. If either source cell changes, Excel recalculates the result automatically.
The ampersand (&) is the simplest operator for joining cell contents. It joins exactly what you specify, so it does not add punctuation or spaces by itself. If A1 contains “Maya” and B1 contains “Chen,” the direct formula returns “MayaChen.” Adding a quoted space between the references returns “Maya Chen.” You can put other text between the references too, such as a comma, hyphen, or slash.
In Excel, text that you type directly into a formula must be enclosed in straight double quotation marks. Cell references do not go in quotation marks: Excel needs to read them as references, not as literal words. The ampersand between each item tells Excel to join those items in order.
Choose a formula for two cells
For two cells, the ampersand is usually the most readable option. Use the layout A1 = Maya and B1 = Chen; to join the values without a separator, enter =A1&B1. The result is “MayaChen.” With the same cell layout, enter =A1&" "&B1 to return “Maya Chen.”
You can use a different separator by changing the text between the quotation marks. With A1 = West and B1 = Coast, enter =A1&"-"&B1 to return “West-Coast.” With A1 = 2026 and B1 = 11, the same pattern using a slash returns “2026/11.” Choose a separator that suits the information; Excel will not know whether the values represent names, dates, codes, or something else.
For a formula using a function rather than an operator, Excel also supports CONCAT. With A1 = Maya and B1 = Chen, enter =CONCAT(A1," ",B1) to return “Maya Chen.” CONCAT joins its arguments in order, and you provide the space as a separate argument. For a simple two-cell join, it produces the same kind of result as the ampersand formula.
Join cells with CONCAT or TEXTJOIN
CONCAT is useful when you prefer a function or need to combine a range of cells. With text in A1, B1, and C1, enter =CONCAT(A1:C1) to join the three values without adding separators. If those cells contain “Maya,” “Chen,” and “Editor,” the result is “MayaChenEditor.” CONCAT does not automatically insert spaces, commas, or other punctuation between items.
TEXTJOIN is more convenient when you want the same delimiter between several cells and may have empty cells. With A1 = Maya, B1 blank, and C1 = Chen, enter =TEXTJOIN(" ",TRUE,A1:C1) to return “Maya Chen.” The first argument is the delimiter, and TRUE tells Excel to ignore empty cells. If you instead want empty cells counted as positions, use FALSE for that argument; with this layout, the result then has two spaces between Maya and Chen.
TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. CONCAT is available in Microsoft 365 and Excel 2019 or later as well. The older CONCATENATE function is retained for compatibility with older workbooks, but Microsoft recommends CONCAT for new formulas. For just two cells, using the ampersand avoids needing to remember a function’s argument structure.
Add punctuation or a label
A combined value can include fixed text as well as cell references. With A2 = Lee and B2 = Jordan, enter =A2&", "&B2 to produce “Lee, Jordan.” This can be useful for displaying a surname and first name in one cell. The comma and following space are literal text, so they must be inside quotation marks.
You can also add a label. With A2 = Order and B2 = 1842, enter =A2&" #"&B2 to return “Order #1842.” This changes only how the value is displayed in the formula result; it does not convert or alter the original cells. For an address, a formula could join a street cell, a comma-space, and a city cell in the same way.
To join a larger list with consistent punctuation, TEXTJOIN can save repetition. With A2 = red, B2 = green, and C2 = blue, enter =TEXTJOIN(", ",TRUE,A2:C2) to return “red, green, blue.” This is different from placing a comma between only two cells: the function applies its delimiter between each included item in the selected range.
Handle blank cells and extra spaces
A blank cell contributes no characters when joined directly, but a separator you typed into the formula still appears. With A1 = Maya and B1 blank, enter =A1&" "&B1; the result has a trailing space after Maya, even though that space may be hard to see. If the blank might occur in either cell, TEXTJOIN with its ignore-empty option is usually cleaner. With the same A1 and B1 layout, =TEXTJOIN(" ",TRUE,A1:B1) returns “Maya” without an extra separator.
There is an important difference between a truly empty cell and a formula that returns an empty string. TEXTJOIN’s ignore-empty setting is intended to skip empty text values, including cells whose displayed result is empty. If a source cell contains spaces rather than being empty, those spaces are still characters and may lead to an awkward result. Clean the source data if it contains unwanted spaces; a join formula does not automatically remove them.
TRIM can remove extra ordinary spaces from text, but it also reduces repeated internal spaces to single spaces. With A1 = a name that contains accidental leading, trailing, or repeated spaces and B1 = another name, enter =TRIM(A1)&" "&TRIM(B1) to clean each part before joining. TRIM is not a general-purpose cleanup for every kind of whitespace, such as nonbreaking spaces copied from some web pages.
Preserve number, date, and time formats
When a number is joined into text, Excel uses the number’s underlying value rather than necessarily copying the way the source cell looks on the worksheet. A cell formatted as currency may therefore appear as an unformatted number in a joined result. Use TEXT when you need to control the number’s appearance in the combined text.
With A2 = Invoice and B2 containing the numeric value 1250, enter =A2&" "&TEXT(B2,"$#,##0.00") to return “Invoice $1,250.00.” The format code specifies a dollar sign, a thousands separator, and two decimal places. This creates text for display; it does not turn the combined result back into a numeric amount that can be summed as a number.
Dates need similar care because Excel stores dates as serial numbers. With A2 = Deadline and B2 containing the date 11/2/2026, enter =A2&": "&TEXT(B2,"mmm d, yyyy") to display “Deadline: Nov 2, 2026.” The visible date depends on the format code you choose. If the result will be used for calculations or sorting as a date, keep the date in its own cell rather than joining it into a text string.
Copy the formula down a column
To combine corresponding pairs of values in many rows, create the formula in the first result row and fill it down. With first names in A2:A20 and last names in B2:B20, enter =A2&" "&B2 in C2. Select C2 and drag the fill handle, the small square at the lower-right corner of the selection, down through C20. Excel adjusts the relative references for each row, so the next result uses A3 and B3, then A4 and B4, and so on.
You can also copy the formula cell and paste it into the destination cells. On Windows, Ctrl+C copies and Ctrl+V pastes; on Mac, use Command+C and Command+V. If the source columns are part of an Excel table, entering a formula in the first row of a table column can fill the formula down that calculated column automatically. Check the results after filling, especially if the data has blank rows or an irregular layout.
Common problems and fixes
- No space between the values: The ampersand joins only the items in the formula. Add a quoted space between the references if the output needs one.
- Text appears instead of a result: Check that the formula begins with an equals sign and that the cell is not formatted as Text. If it is, change the cell format to General, then edit and re-enter the formula.
- Unexpected spaces: Look for spaces already present in the source cells. A formula-added separator can combine with them, producing double spaces or spaces at the start or end.
- A number or date looks different: Joining a value does not automatically preserve its cell formatting. Use TEXT with an appropriate format code when the joined output needs a particular display.
- The formula shows an error: Check that referenced cells themselves do not contain errors. A join formula generally passes a source error through to its result rather than hiding it.
- A formula copied down points to the wrong cells: Relative references change as a formula is filled. If a reference must remain fixed, add dollar signs to it; for a basic row-by-row join, relative references are usually what you want.
Frequently Asked Questions
What is the simplest Excel formula to combine two cells?
Use the ampersand between the cell references. With the values in A1 and B1, =A1&B1 joins them without a separator. Add a quoted space between the references when the result should read as two words.
How do I combine two cells with a space in Excel?
With the values in A1 and B1, enter =A1&" "&B1. The space inside the quotation marks is included in the result. If one of the cells may be blank, TEXTJOIN can avoid an extra separator.
Is CONCAT better than the ampersand?
Neither is always better. The ampersand is concise for two cells and makes separators easy to see. CONCAT can be convenient for joining a range, while TEXTJOIN is a better fit when you want a delimiter and need to ignore empty cells.
Can I combine cells without changing the original values?
Yes. Put the formula in a separate cell; it displays the combined result while leaving the source cells intact. Copying the formula result and using Paste Special > Values can replace formulas with their current text results if you need a fixed output, but that step is not necessary for ordinary use.
Why did my date become a number when I combined it with text?
Excel dates are stored as serial values, and concatenation may use that underlying value instead of the cell’s display format. Wrap the date reference in TEXT and specify a date format code to show a readable date in the combined result.
Related
- Excel Data Validation Restrictions and Their Limits
- Data Validation Process: Steps, Checks, and Best Practices
- Data Validation Named Range in Excel: Setup and Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- XLOOKUP Excel Conditional Search: Formulas and ExamplesTo use XLOOKUP for a conditional search in Excel, put the condition in its lookup array; for multiple…
- Excel Day of Week from Date: Formulas and FormattingIf your date is in A2, enter =TEXT(A2,"dddd") to show its full weekday name; for example, an actual…
- Count Unique Values in Excel with a Simple FormulaTo count distinct, nonblank entries in a column in Microsoft 365, enter =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0) in an empty cell, replacing…
- Excel Formula: Years, Months, and Days Between DatesTo calculate complete years, months, and remaining days between dates in Excel, use DATEDIF for the years and…
- Excel Lookup Formula Examples for Common TasksExcel lookup formulas find a value in one range and return a related value from another. In Microsoft…
- Excel AND Function: Why It Does Not Return an ArrayExcel’s AND function returns one value, either TRUE or FALSE; it does not return a separate result for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.