Someone asked a human this. So we asked the AI.
How to Concatenate Strings in Excel (With Examples)
Joining two bits of text in a spreadsheet is the exact job the ampersand was invented for, and yet here we are.
The answer
To concatenate strings in Excel, join the cells with the & operator, for example =A2&" "&B2, or use the CONCAT or TEXTJOIN functions.
Option 1: the & operator (works in every version)
- Click the cell where you want the result.
- Type
=A2&B2and press Enter. - To add a space, a comma or other text between the pieces, put it in quotes:
=A2&" "&B2or=A2&", "&B2. - Drag the fill handle (the small square at the bottom-right corner of the cell) down to copy the formula.
The result is a formula. To keep only the joined text, select the result cells, copy them with Ctrl+C (Cmd+C on Mac), then use Paste Special > Values.
Option 2: CONCAT
=CONCAT(A2," ",B2) joins the items in order. It also accepts ranges, such as =CONCAT(A2:C2), but it adds no separator. The old CONCATENATE function still works the same way as CONCAT with single cells, but does not accept ranges.
Option 3: TEXTJOIN (best with a delimiter)
=TEXTJOIN(delimiter, ignore_empty, range). For example, =TEXTJOIN(" ",TRUE,A2:C2) joins A2 to C2 with a space between them and skips empty cells (that is what TRUE does). Use FALSE to keep empty cells, which leaves a doubled delimiter.
CONCAT and TEXTJOIN are available in Excel 2019, Excel 2021/2024 and Microsoft 365, including Excel 2016 if it comes with a Microsoft 365 subscription. Standalone Excel 2016 and earlier do not have them; use & there.
Join a whole column into one cell
=TEXTJOIN(", ",TRUE,A2:A100) combines every non-empty cell in A2:A100 into a single comma-separated text.
Line breaks
Use CHAR(10) as the separator: =A2&CHAR(10)&B2 or =TEXTJOIN(CHAR(10),TRUE,A2:C2). The break only shows if Wrap Text is on for the cell (Home > Wrap Text). CHAR(10) is the line break on Mac too.
Numbers and dates
Joining a date or formatted number shows its raw value (a date becomes a serial number like 45292). Wrap it in TEXT: =A2&" "&TEXT(B2,"dd/mm/yyyy"). Format codes depend on your language and regional settings; in some non-English versions of Excel the codes differ (for example, the year letter is not y), so use the letters your Excel version shows in Format Cells > Custom.
No formula needed: Flash Fill
Type the combined result for the first row by hand, then press Ctrl+E in the next cell. Excel fills the pattern down as plain text, not formulas.
Example
A2 contains Anna, B2 contains Berg, C2 contains Oslo, and B3 holds the date 5 March 2024.
=A2&" "&B2givesAnna Berg=A2&", "&B2&", "&C2givesAnna, Berg, Oslo=TEXTJOIN(" - ",TRUE,A2:C2)givesAnna - Berg - Oslo=A2&" "&B2&CHAR(10)&C2givesAnna BergwithOsloon a second line (Wrap Text on)="Date: "&TEXT(B3,"dd/mm/yyyy")givesDate: 05/03/2024
Where people go wrong
Forgetting the quotes around the space or comma.
=A2&" "&B2works,=A2& &B2gives an error. Any literal text must be in double quotes.Using CONCAT or TEXTJOIN in standalone Excel 2016 or earlier, which shows #NAME?. Use the
&operator instead.Joining a date or percentage and getting a number like 45292 or 0.25. Wrap the cell in
TEXT, for exampleTEXT(B2,"0%").Using TEXTJOIN with
FALSEon a range with blanks, which produces doubled delimiters likea, , b. UseTRUEto skip empty cells.Using CHAR(10) and seeing no line break. Turn on Wrap Text for the cell.
The prompt you could have used
I have first names in column A and last names in column B in Excel. Give me a formula that joins them with a space, skips blanks, and tell me how to turn the results into plain text.
Updated 16 November 2026. Written by an AI and fact-checked by a second one before it went up; anything they weren't sure of was left out.
Someone asked you something like this? Send them a link →
More questions nobody needed to ask
- Excel IF Formula With Multiple Conditions (With Examples)
- How to Fix the #N/A Error in Excel (Causes and Fixes)
- How to Use SUMIF in Excel (With Examples)
- Percentage Change Between Two Numbers in Excel
- How to Delete a Git Branch (Local and Remote)
More Excel questions · All questions · Just Fucking Prompt It