To combine text in Excel, you can join the values of two or more cells with the ampersand, the CONCAT function, the TEXTJOIN function or Flash Fill. These tools are used to build full names from first and last names, create addresses, make product codes and prepare data for mailing. The basic idea is simple, but spaces, commas, dates and numbers cause common problems. This guide explains every method with working formulas, shows how to add separators, handle blanks, format dates and numbers inside text, and fix errors.
Updated November 2026
In this guide
- The quick answer
- Method 1: the ampersand operator
- Method 2: CONCAT and CONCATENATE
- Method 3: TEXTJOIN for separators and blanks
- Method 4: Flash Fill
- Examples table
- Combining text with numbers and dates
- Adding line breaks
- Worked example: building email addresses and IDs
- Combine text from a whole column or table
- Combining text in Google Sheets
- Quick recap
- Checking your result
- Common problems and fixes
The quick answer
If first names are in A2 and last names in B2, type =A2&" "&B2 in C2 to get a full name. The ampersand joins text, and the quotation marks around a space add a space between the names. Alternatively, use =CONCAT(A2," ",B2). Both return the same result, for example Ayesha Khan. Fill the formula down to apply it to the whole list. For the official description of CONCAT, see Microsoft’s page on the CONCAT function.
Method 1: the ampersand operator
The ampersand is the simplest way to combine text. You can chain as many items as you need: =A2&", "&B2&", "&C2 joins three cells with a comma and a space between them. You can also mix cell values with fixed text, such as ="Order "&A2&" ships on "&TEXT(B2,"mmm d"). Every piece of fixed text must be in quotes, and cell references are not. The ampersand works in every version of Excel and in Google Sheets, which makes it the best choice when you share files.
Method 2: CONCAT and CONCATENATE
CONCAT joins text from several arguments or from a whole range. The formula =CONCAT(A2:C2) joins A2, B2 and C2 with nothing between them, which is useful for building codes. The older CONCATENATE function still works, but it cannot accept a range, so you must list each cell separately. CONCAT is available in Excel 2019 and Microsoft 365. If your file will be opened in an older version, use the ampersand or CONCATENATE for compatibility. Neither function adds separators on its own, so include them as extra arguments, for example =CONCAT(A2,"-",B2,"-",C2).
Method 3: TEXTJOIN for separators and blanks
TEXTJOIN is the best choice for lists. Its syntax is =TEXTJOIN(delimiter, ignore_empty, text1, text2, ...). For example, =TEXTJOIN(", ",TRUE,A2:E2) joins the values in A2 to E2 with a comma and a space, and it skips empty cells when the second argument is TRUE. That avoids ugly double commas when some cells are blank. TEXTJOIN is available in Excel 2019 and Microsoft 365. It can also join a whole column into one cell, such as =TEXTJOIN(", ",TRUE,A2:A20), which is handy for making a mailing list or a tag list.
Method 4: Flash Fill
Flash Fill detects a pattern and fills the rest. Type the first full name by hand in C2, for example Ayesha Khan, then start typing the second in C3. Excel shows a gray preview. Press Enter to accept, or choose Data, then Flash Fill, or press Ctrl+E. The result is static text, not a formula, so it will not update when the source changes. Use it for quick one-off jobs where speed matters more than a live link.
Examples table
These results come from the formulas above.
| First (A) | Last (B) | Formula | Result |
|---|---|---|---|
| Ayesha | Khan | =A2&” “&B2 | Ayesha Khan |
| Bilal | Ahmed | =B3&”, “&A3 | Ahmed, Bilal |
| Sara | Ali | =CONCAT(A4,”.”,B4) | Sara.Ali |
| Omar | Malik | =LOWER(A5&”.”&B5) | omar.malik |
Combining text with numbers and dates
When you join a number or a date, Excel uses the underlying value, which can look odd. A date such as 15 March 2026 is stored as a serial number, so ="Due: "&A2 may show Due: 46096 instead of a date. Use the TEXT function to format it: ="Due: "&TEXT(A2,"dd mmm yyyy") returns Due: 15 Mar 2026. For currency, use =TEXT(B2,"$#,##0.00"). For percentages, use =TEXT(C2,"0.0%"). A number such as 5 joined to a unit works as =B2&" kg". The result is text, so you cannot add it up afterward, and if you need to calculate with it, keep the raw number in another column.
Adding line breaks
To combine text on separate lines in one cell, use CHAR(10) as the separator and turn on Wrap Text. For example, =A2&CHAR(10)&B2&CHAR(10)&C2 puts the name, street and city on three lines. In Excel for Mac, CHAR(10) also works. This is helpful for mailing labels or for building a multi-line address. If the cell shows the text on one line, select it and click Wrap Text on the Home tab.
Worked example: building email addresses and IDs
Suppose you have first names in A2:A4 (Ayesha, Bilal, Sara) and last names in B2:B4 (Khan, Ahmed, Ali), and your company domain is example.com. To build an email address, use =LOWER(A2&"."&B2&"@example.com"), which returns ayesha.khan@example.com. To build an employee ID from the first letter of the first name, the last name and a number in C2 (say 101), use =UPPER(LEFT(A2,1))&UPPER(B2)&C2, which returns AKHAN101. If you need a sortable code with leading zeros, use =UPPER(LEFT(A2,1))&TEXT(C2,"0000"), which returns A0101. These small patterns save hours when you prepare a staff list, a customer file or an import for another system.
Combine text from a whole column or table
To collect all the values in a column into one cell, use TEXTJOIN with the range: =TEXTJOIN(", ",TRUE,A2:A50). To include only matching rows, combine TEXTJOIN with IF in Microsoft 365, for example =TEXTJOIN(", ",TRUE,IF(B2:B50="Paid",A2:A50,"")), which lists the names of customers who have paid. In older versions this needs Ctrl+Shift+Enter. If the result is longer than 32,767 characters, Excel truncates it, so split big lists. For many-to-one joins, PivotTables can also group names, but TEXTJOIN gives you a ready string to paste into an email or a message.
Combining text in Google Sheets
Google Sheets supports the ampersand, CONCATENATE and TEXTJOIN with the same syntax. It also has JOIN, which uses the delimiter first: =JOIN(", ",A2:A10). The TEXT function works the same way, though some format codes differ between locales. If you share a workbook between Excel and Sheets, test the formulas in both, since small differences in function names can cause errors. When in doubt, the ampersand works everywhere.
Quick recap
Use the ampersand for simple joins, CONCAT for ranges, TEXTJOIN when you need separators and blanks skipped, and Flash Fill for one-off tasks. Always wrap dates and numbers in TEXT so they look the way you want, use TRIM to clean extra spaces, and paste as values when you want to keep the result. With these tools you can build names, addresses, emails and codes in seconds instead of typing them by hand.
Checking your result
After you build the formulas, spot-check three or four rows by reading the result aloud against the source cells. Look for stray spaces at the start or end, for missing separators and for dates that appear as numbers. A quick way to find hidden spaces is to compare the length of the text with =LEN(C2) and the expected number of characters. Fix the source data once and the formulas will fix themselves everywhere.
Common problems and fixes
If your result has extra spaces, wrap the source in TRIM, as in =TRIM(A2)&" "&TRIM(B2). If you see a formula instead of the result, the cell is formatted as Text, so change it to General and re-enter. If you get #NAME?, you may have missed the quotation marks around fixed text or you are using CONCAT in an old Excel version. If you need to split the combined text again later, use Text to Columns or a function such as TEXTSPLIT in Microsoft 365. Finally, when you must keep the combined values and delete the source columns, copy the results and use Paste Special, then Values, so that the text stays when the formulas disappear.
Frequently asked questions
How do I combine two cells in Excel?
Use =A2&” “&B2 or =CONCAT(A2,” “,B2).
What is the difference between CONCAT and TEXTJOIN?
CONCAT joins values with no separator. TEXTJOIN adds a delimiter and can skip empty cells.
How do I add a space between combined text?
Add a space in quotes as a separate item, for example =A2&” “&B2.
How do I combine text and a date?
Format the date with TEXT, for example =TEXT(A2,”dd mmm yyyy”).
How do I keep the result after deleting the source?
Copy the result and paste as values.
Related guides and free tools
- How to Capitalize the First Letter in Excel
- How to transpose in Excel
- VLOOKUP not working: 8 fixes
- IF statements in Excel
- COUNTIFS in Excel
- All free calculators
- All free calculators and templates
Sources: CONCAT function, Microsoft Support


