If set to FALSE, the delimiter is returned nonetheless, resulting in consecutive delimiters with no values in-between. The ignore_empty argument is required and is a setting that tells Excel what to do if empty cells occur within the range. The syntax of TEXTJOIN is: TEXTJOIN (delimiter, ignore_empty, text1, , … ) TEXTJOIN can be considered an improvement in the efficiency of CONCAT since it allows repetitive delimiters (characters between values) to be entered once. If additional characters are required between cell values, these would be entered within double quotes and separated by commas as is usually the case with function arguments. We can merge the contents of cells A2 to C2 in cell D2 with the entry: = CONCAT ( A2 : C2 ) The syntax of the CONCAT function is: = CONCAT (text1. This would work well in the case of the dataset below: The CONCAT function allows the selection of a range and is therefore potentially quicker than using the & symbol, especially when no additional characters are required between the cell values being joined. Since a space is also likely desired between the first and last names, we would also enter a space within double-quotes. Next, separate each value with the & symbol. Using the & symbol as a concatenation operator is a popular choice because knowledge of function formats is not required although this method is, technically speaking, a formula.Īs with all Excel formulas, we would begin with an equal sign.
Excel split cells on a new line full#
Using the ampersand (&) symbol between values will join them in a string.įor example, in the dataset below, let’s say we want to have the full name of each individual shown in a single column, column C. Merge cells using the concatenation operator