N/APosted on - 05/31/2017
Hi, I am a new user having a laptop with Win 7 in it. I have recently starting to learn MS Office. I am facing many problems using MS Excel. I don’t know the process of Merging Two Cells In Excel. Please help me. Thanks in advance.
Learning The Process Of Merging Two Cells In Excel In Excel 2016?
Hi, Merging Two Cells In Excel can be done by selecting the two cells and then clicking on the Merge & Center option and then choosing the Merge Cells option under it. The screenshot has been given above. But this method has one problem, and that is it only restores the value of the upper left cell. However, this can be helped.
In the above method, you are relieved from losing data while merging. You just need to type the cell numbers using the formula (=A1&” “&B1&” “&C1) and press enter. Your merging has been done without losing data.