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

Asked By Thomas D Ponton 0 points N/A Posted 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.

• Status: Open
• Question Views: 755
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Office
• Question Tags: Excel | MS Office

Answered By Robert A Ryan 0 points N/A #298110

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.

About Robert A Ryan

Questions
2

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/31/2017
• Question Category: Microsoft Office