
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