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)

  1. Click the cell where you want the result.
  2. Type =A2&B2 and press Enter.
  3. To add a space, a comma or other text between the pieces, put it in quotes: =A2&" "&B2 or =A2&", "&B2.
  4. 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.

Where people go wrong

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.

Watch the AI answer it →

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

More Excel questions · All questions · Just Fucking Prompt It