We apply the following CONCATENATE excel formula to join the names of cells and B2 "=CONCATENATE(,B2)" The output of the formula is shown in cell C2 The first and the last name are joined without a space between them As a result, the readability of the full name in cell C2 is affected To introduce a space between the first and the last names, let us pass another Re Concatenating cell values to create sheet names You can use =a1&a2 to concatenate a couple of cells To refer to that in another formula, you'd need something like =indirect ("'" & a1&a2 &"'!A1") or if there's a chance your concatenated string refers to a nonexisting worksheet and you want to avoid a #ref! CONCATENATE Excel Ranges Using TEXTJOIN Function (available in Excel with Office 365 subscription) In Excel that comes with Office 365, a new function – TEXTJOIN – was introduced This function, as the name suggests, can combine the text from multiple cells into one single cell It also allows you to specify a delimiter
1
