Harness Textjoin: The Ultimate Guide To Concatenating Text In Google Sheets
To use TEXTJOIN, specify a separator character (e.g., “, “) and optionally ignore empty strings. Then, provide up to 255 text strings to be concatenated, including cell values, constants, or expressions. Execute the function by entering “=TEXTJOIN(separator, ignore_empty, text1, text2, …)” into a cell, replacing “separator”, “ignore_empty”, and “{textn}” with the appropriate values and arguments….