Formulas -> Function Library-> Text ->Concatenate Text Formula Options This formula combines two cells: B2, the name of the Product, with E2, the calculated revenue.   4. Try It: Edit the Text Function Start by entering the cell references.   Edit Text1: B2 Edit Text2: E2   What Do You See? The formula is =CONCATENATE(B2,E2)   This TEXT formula did, indeed, combine the fields. However, this result needs some improvements. Keep going...