Wednesday, 28 December 2011

Adding two or more cells in excel

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.


No comments:

Post a Comment