Additional Text Fields

If you add additional Text fields, you can include labels and punctuation if you wish.


5. Try This: Use Additional Text Fields

Select Cell F2 and delete the formula.

Select Cell F2, again.

Go to Formulas -> Function Library-> Text.

Click on Concatenate.

Edit Text1: "Daily Sales for "

Edit Text2: B2

Edit Text 3: ": $ "

Edit Text 4: E2


Try This, Too: AutoFill the Formula

Select Cell F2.

AutoFill Cell F2 to the bottom of Column F.


What Do You See? Does your formula include the additional Text fields in the Concatenation?


Memo to Self: Whatever is in quotes will be placed in the answer. If you need a space between the "$" sign and the number, then add a space to Text3 between the quotes.

Formulas -> Function Library-> Text ->Concatenate


Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: TEXT Functions CONCATENATE