How do you mix text and formulas??

I want the cell C46 to have the text 'ABS' and the the formula '=Core!D55'
to the right.

Since the formula is just a reference to an average, the output of the cell
should look like this:
ABS 8.5

Thanks!!!