Step 1: Combine each fruit and price of two different cells into one cell. For combining them, you need to enter the following formula in cell C2: =CONCATENATE ("Price of"," ",A2," ","is ₹",B2) Step 2: Enter the formula in cell C2. After that, you may obtain the result, "Price of Apple is ₹250.".