One way:

="The result is " & B5

In article ,
ronald wrote:

I would like to create a an if function that would display the contents of a
cell. I have only been able to get the function to display the text I typed
in the formula but not the value of the cell. Example: Value of cell B5 is
50. I want the the if function in cell D5 to display "The result is 50" and
not "The result is B5." How do I do this?