This site uses cookies to give you the best experience of this website. Cookies are small units of data temporarily stored by your browser. The cookies in use do not contain any personal information about you and cannot be used to identify an individual user.
1 Highlight or select a range of cells. 2  Right-click on the highlighted cells and select Format Cells.... 3  Click the Alignment tab and place a checkmark in the checkbox labeled Merge cells.  To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. Again, this will only preserve the text in the upper-leftmost cell. Highlight or select a range of cells.
Combine Using IF. Use an IF function when you want Excel to perform one formula in certain conditions or another formula in different conditions. With IF, you get to write two separate formulas in one cell, but only one of the two operates at any time. credit: Image courtesy of Microsoft.