Use Cell References and Label Text in Formulas
To use cell references, together with label text, in a formula, type an ampersand (&) in between the reference and the text. For example, to display "25 Departments," type (=A1&" Departments"), where cell A1 contains the number 25.