That means if a student is passed in both of the subjects then heshe will pass. Press and hold Ctrl and click on each cell you want to concatenate. One way to give yourself some flexibility with formatting is to combine text and the results of a formula in a single cell.
And the best part is you can combine other functions with IF to increase its power.
Select the cell in which you want the combined data. To do that Ill just hard-code the text Item at the start of the formula then use the ampersand to join the text to the padded number we already created. This process activates all the functions or formulas of excel. Click on the first cell.