Question

Q3 How will you combine A1 to A5 cells to make them a single cell? Explain step wise.​

Answer 1

Answer:

select cell A1 and B1 and use the Merge & Center option, it will keep the text from the leftmost cell (A1 in this case) and remove the text from all other cells.

Excel is not completely ruthless though – it warns you before this happens. If you try and merge cells which have text in it, it shows a warning pop-up letting you know of this (as shown below).