Question 1

How do I add a space or separator between concatenated values?

Accepted Answer

Include a string argument for the separator, e.g. ", " or " - " between cell references: =CONCATENATE(A1, " - ", B1).

Question 2

What is the difference between CONCATENATE and TEXTJOIN?

Accepted Answer

CONCATENATE joins arguments in order; TEXTJOIN lets you specify a delimiter once and can ignore empty cells. In Excel 2016+ and Sheets, TEXTJOIN is often easier for lists.

Question 3

Why does CONCATENATE show a number without formatting?

Accepted Answer

Concatenation turns numbers to plain text. Use TEXT() to format: =CONCATENATE(TEXT(A1,"0.00"), " ", B1).

Question 4

How do I concatenate a date with text?

Accepted Answer

Wrap the date in TEXT() so it displays as you want: =CONCATENATE(TEXT(A1,"yyyy-mm-dd"), " ", B1).

Question 5

Can I use CONCATENATE with more than 3 items?

Accepted Answer

Yes. Add more arguments: =CONCATENATE(A1, " ", B1, " ", C1). In Google Sheets and Excel 2016+, TEXTJOIN is simpler for many values.

CONCATENATE Generator - Join Text with Separator | Excel & Sheets

Learning Resources

Common Errors & Fixes

No space or wrong separator between values

Related Formulas

Want to become an Excel Pro?