Sometimes you may need to add two or more cells together in excel. for example, you want to add name and
surname of
people from your table given below .
Now in column C, I want to get them together as a title of Name-Surname. the formula is =A1&A2. through this you will get result is
ChompaChameli,
SheuliShefali ... If you want to leave a space between name & surname this time you have to use the formula =A1&" "&A2 and you will get the result like
Chompa Chameli,
Sheuli Shefali......
you can see the result of using the formula for the given table here.