Question

How can we merge multiple cells’ text strings in a cell?

Answer 1

We can merge multiple cells text strings by using the Concatenate function and “&” function.

Example: We have three names: First Name, Middle name, Last name in 3 columns. To merge the names and make it a full name, follow the steps below :
Concatenate Function

• Enter the formula in cell D2
• =CONCATENATE(A2,” “,B2,” “,C2)