Text Joining Formula Generator
Combine text from multiple cells into one. TEXTJOIN is the modern approach with a separator and the ability to skip blanks. CONCATENATE and the & operator work in all versions.
Syntax
=TEXTJOIN(delimiter, ignore_empty, range1, [range2], ...)Try it — generate a CONCATENATE / TEXTJOIN formula
Examples
Full name from first and last
=A2&" "&B2Joins first name (A2) and last name (B2) with a space.
Comma-separated list
=TEXTJOIN(", ", TRUE, A2:A20)Joins all non-empty cells in A2:A20 with ", " between them.
Tips
- ✓TEXTJOIN is cleaner than CONCATENATE for joining ranges — it handles separators and blanks automatically.
- ✓The & operator is the simplest way to join two cells: =A1&" "&B1.
- ✓Use CHAR(10) as a separator in TEXTJOIN to create line breaks within a cell.
Related Formulas
Text Split / Extract
Split text into parts, extract substrings, or parse structured data like email a...
UNIQUE
UNIQUE returns a list of distinct values from a range, removing duplicates. It's...
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free