Learning The Process Of Merging Two Cells In Excel In Excel 2016?

Asked By 0 points N/A Posted on -
qa-featured

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.

Image result for Merging Two Cells In Excel
SHARE
Answered By 0 points N/A #298110

Learning The Process Of Merging Two Cells In Excel In Excel 2016?

qa-featured

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.

Image result for Merging Two Cells In Excel

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.

Login/Register to Answer

Related Questions