FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

Detailed explanation-2: -The TEXTJOIN function uses the following arguments: Delimiter (required argument) – The string that is inserted between each text value in the resulting string. The most common delimiters used are a comma or a space character.

Detailed explanation-3: -You can use the formula =TEXTJOIN(“ “, 1, A2, B2) to join the names in cells A2 and B2 together with a space in between them. Notice that here I have used a binary input for ignore empty. The formula=TEXTJOIN(”, ”, 1, A3, B3) will join the names in cells E2 and B2 together with a comma in between them.

Detailed explanation-4: -Both of these functions let you join (concatenate) text in different cells together. TEXTJOIN lets you join values with a delimiter of your choice, and has an option to ignore empty values. CONCAT simply mashes all values together without options.