CONCATENATE Generator - Join Text with Separator | Excel & Sheets
Joins several text strings into one text string.
Common Errors & Fixes
No space or wrong separator between values
Causes:- Forgetting to add a separator string between references.
- Using a number instead of quoted text for the separator.
Fixes:- Add ", " or " - " (or any separator in quotes) between each pair of values.
- Always put literal text in double quotes.
Frequently Asked Questions
How do I add a space or separator between concatenated values?
Include a string argument for the separator, e.g. ", " or " - " between cell references: =CONCATENATE(A1, " - ", B1).
What is the difference between CONCATENATE and TEXTJOIN?
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.
Why does CONCATENATE show a number without formatting?
Concatenation turns numbers to plain text. Use TEXT() to format: =CONCATENATE(TEXT(A1,"0.00"), " ", B1).
How do I concatenate a date with text?
Wrap the date in TEXT() so it displays as you want: =CONCATENATE(TEXT(A1,"yyyy-mm-dd"), " ", B1).
Can I use CONCATENATE with more than 3 items?
Yes. Add more arguments: =CONCATENATE(A1, " ", B1, " ", C1). In Google Sheets and Excel 2016+, TEXTJOIN is simpler for many values.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More