Note the formula in the formula bar while the result we would expect is in cell B2. If we want to insert a formula in Excel then we need to get into the edit mode of the cell where we want to apply and then type equal sign. To do that first select the cells of the column where you want to insert the formula along with the formulated cell.
If we want to getreturn the formula in a cell then we can use the Formula property.
We can add the text values according to our preferences either by using the CONCATENATE function in excel or ampersand. You can use a keyboard shortcut to insert the formula for the entire column of your worksheet. Note the formula in the formula bar while the result we would expect is in cell B2. Use multiplication instead of adding the same item over and.