Excel - how to add two cell values in single cell (Easy steps)
Excel - how to add two cell values in single cell (Easy steps) You might be having lot of data in excel and you want to add the multiple cells and give the value in single cell. do not worry there are many ways to do it but today I am going to teach you a simple and easiest way to do it. Example: You may be having the below values in excel Cell A1 = First Name Cell B1 = Last Name How can you add it in both of the values in single cell? so follow these easy steps below: As shown in above image in Cell Al there is a First Name, that is Narendra and in cell B2 Modi- so you can add both with the below formula: =A1&B1 So the result will be as shown below: So in above image the both cells value (A1 & B1) is combined and pasted in cell C1 but there is no "Space" between the two value; If you want to add a space between then follow with be low steps. the formula will be : =A1&" "&B1 (cell A1 and type space in quo
