Service
141 Points
Joined December 2008
In case we want to combine the values in multiple cells in excel, we use "CONCATENATE" function. For example, we want to combine the values of cell A1 and B1 the formula will be =Concatenate(A1,B1).
Why this function has been mostly unused because we can get the same result by using "&". For example, in the above case we can get the same result by =A1&B1.