EXCEL: inserting data in between text

Could anyone advise how to insert a prticular value calculatd by Excel into a text. e.g.

say Cell A1 should = The value of should be used for the current month.

How do I insert a calculated value from another cell into the above text in A1 “The value of (actual value) etc.