Use the ampersand to concatenate text and formula result; for example, if A1 is 16 and A2 is 12 ="Foobar "& A1+A2 will display Foobar 28