You can merge cells in Excel by using a simple drop-down menu, which will let you merge cells in a variety of ways. Here's ...
To add a formula in Google Sheets, click the cell where you want the answer, then choose one of the hundreds of functions.