Join cells with the & operator

=A1&" "&B1

Each piece of literal text, like the space, goes inside double quotes, and the & stitches everything into one string. Add as many pieces as you need: =A1&", "&C1.

Use the CONCAT function

=CONCAT(A1, " ", B1)

CONCAT does the same job with a function syntax that some people find easier to read, especially when joining many cells.

Join a whole range with TEXTJOIN

=TEXTJOIN(", ", TRUE, A1:A10)

TEXTJOIN places a delimiter between every value. The second argument TRUE tells it to skip empty cells, so you avoid stray commas.

Common mistakes / tips

  • Missing spaces. Joining cells directly gives “JohnSmith”; add " " between them.
  • Quote literal text. Any words or punctuation you type need double quotes.
  • Numbers lose formatting. Wrap a date or currency in TEXT, like TEXT(B1,"0.00"), before joining.

Frequently asked questions

What is the difference between CONCAT and TEXTJOIN?

CONCAT simply joins everything you list. TEXTJOIN adds a delimiter between each item and can skip blanks, which makes it better for combining a column of values.

How do I add a line break between joined cells?

Use CHAR(10) as the joiner, like =A1&CHAR(10)&B1, and turn on Wrap Text so the break shows.

String handling is far more powerful in code. Take the next step with our free Pandas course.