How to concatenate cells in Excel
This post shows how to concatenate cells in Excel. concatenate() function concatenates cells =concatenate(A1,A2) Suppose we have the following data: The & operator can be used to concatenate cells. The following image show the result of =A1&B1: concatenate function can also be used; =concatenate(A1,B1) Quoted text can be used...
How to strikethrough text in Excel
This post shows how to strikethrough text in Excel. Select cells and press ctrl+shift+F simultaneously. You will see the format cells window. Click to check Strikethrough and click on OK. You should see the following: Related Articles:...
How to merge and unmerge cells in Excel
In this post, you will learn how to merge and unmerge cells in Excel. Select cells and then click on Home tab in the menu followed by Merge and Center in the Alignment section of the ribbon. Click on Unmerge to unmerge the cells. Following are detailed step-by-step instructions:...