USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
LEFT
|
|
|
PROPER
|
|
|
TEXTJOIN
|
|
|
RIGHT
|
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: -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-3: -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.