TEXTJOIN

Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.

Sample Usage

TEXTJOIN(“ “, TRUE, “hello”, “world”)

TEXTJOIN(“, ”, FALSE, A1:A5)

Syntax

TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])

  • delimiter - A string, possibly empty, or a reference to a valid string. If empty, text will be simply concatenated.

  • ignore_empty - A boolean; if TRUE, empty cells selected in the text arguments won't be included in the result.

  • text1 - Any text item. This could be a string, or an array of strings in a range.

  • text2, ... [OPTIONAL] - Additional text item(s).

See Also

JOIN: Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.

CONCATENATE: Appends strings to one another.

Example

  A B
1 Data  
2 Hello  
3 there  
4    
5    
6 Sheets  
     
8 Result Formula
9 Hello there Sheets =TEXTJOIN(" ", TRUE, A2:A6)
10 Hello there   Sheets =TEXTJOIN(" ", FALSE, A2:A6)
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
11464762748183518783