FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Merge table cells. To combine two or more table cells in the same row or column into a single cell, do the following: On the slide, select the cells that you want to combine. Tip: It is not possible to select multiple, noncontiguous cells.

Detailed explanation-2: -However, merged cells are notorious for creating problems in spreadsheets; especially if you’re trying to sort, copy, paste, or move data. Because of this, it’s generally best to avoid merging cells unless you absolutely have to.

Detailed explanation-3: -Use the CONCATENATE function: Click Text functions and select CONCATENATE. Enter A1 in the text1 field, B1 in the text2 field, and C1 in the text3 field. Click OK. The columns are combined.