Additional Text Fields
If you add
additional Text fields, you can include labels and punctuation if
This: Use Additional Text Fields
Cell F2 and delete the formula.
Cell F2, again.
Formulas -> Function Library-> Text.
Text1: "Daily Sales for "
3: ": "
This, Too: AutoFill the Formula
Cell F2 to the bottom of Column F.
You See? Does your formula include the
additional Text fields in the Concatenation?
Memo to Self: Whatever you type between the quotes will be displayed as text between the Concatenated Cells. If you need a space between the
": " colon and the number, then add a space to Text3 between the