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



This TEXT formula did, indeed, combine the fields. However, this result needs some improvements. Keep going...

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: TEXT Functions CONCATENATE