CONCATENATE / TEXTJOIN Formula Generator
Describe what you want to combine in plain English and get a ready-to-use CONCATENATE, &, or TEXTJOIN formula for Excel or Google Sheets.
5 free tries without an account
CONCATENATE and TEXTJOIN syntax
=CONCATENATE(text1, [text2], ...)
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)CONCATENATE (and the & operator) just glue text pieces together in order. TEXTJOIN adds a delimiter that's inserted automatically between every piece, plus the option to skip blanks — much less typing when you're joining more than two or three cells. Formulon picks whichever fits your description and inserts the right separators.
Examples
Combine first and last name with a space
=A2&" "&B2Joins the value in A2, a literal space in quotes, and the value in B2 into one text string — e.g. "John" and "Smith" become "John Smith".
Join a range of cells with commas, skipping blanks
=TEXTJOIN(", ",TRUE,A2:A10)Combines every non-blank cell from A2 to A10 into one string, separated by ", " — the TRUE argument tells it to ignore empty cells instead of adding extra commas for them.
Frequently asked questions
What's the difference between CONCATENATE, &, and TEXTJOIN?
CONCATENATE and the & operator both join text values with no built-in separator handling — you insert delimiters manually between each piece. TEXTJOIN adds a delimiter argument and an option to skip blank cells, and can take an entire range instead of listing each cell.
How do I join text with a separator like a comma or space?
With CONCATENATE or &, insert the separator as its own piece: =A2&", "&B2. With TEXTJOIN, set it once as the first argument: =TEXTJOIN(", ",TRUE,A2:C2).
Can I join a whole range of cells at once?
Yes, but only with TEXTJOIN — it accepts a range directly, e.g. =TEXTJOIN(", ",TRUE,A2:A10). CONCATENATE and & require every cell to be listed individually.
Is CONCATENATE the same in Google Sheets?
Practically yes — CONCATENATE, &, and TEXTJOIN all work the same way in both. Google Sheets also has its own CONCAT function, which is more limited (exactly two arguments) and rarely needed over CONCATENATE or &.
Don't want to write it by hand?
Describe what you need in plain English and get a ready-to-use formula in seconds.
Try the formula generator