TEXTJOIN Function
Joins text from multiple cells with a delimiter between each value. Can optionally skip empty cells. Superior to CONCATENATE for most use cases.
ExcelGoogle Sheets
Sintaxis
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)Parámetros
| Parámetro | Descripción |
|---|---|
| delimiter | The separator between each text value (e.g., ", " or " - "). |
| ignore_empty | TRUE to skip empty cells, FALSE to include them. |
| text1 | The first text value or range. |
| textN(opcional) | Additional text values or ranges. |
Ejemplos
Join a range with commas
=TEXTJOIN(", ", TRUE, A2:A10)Resultado: Apple, Banana, Cherry
Create a file path
=TEXTJOIN("/", FALSE, "Users", A1, "Documents")Resultado: Users/john/Documents
Consejos y buenas prácticas
- •TEXTJOIN accepts entire ranges — unlike CONCATENATE which needs individual cells.
- •Set ignore_empty to TRUE to avoid double delimiters from blank cells.
- •Available in Excel 2019+ and Google Sheets.
Fórmulas relacionadas
¿Necesitas otra fórmula?
Describe lo que necesitas en texto simple y nuestra IA generará la fórmula por ti.
Probar el Generador de fórmulas