|You can use either the Concatenate Operator, the ampersand:|
="The Diameter will increase like D = " & 1000 + (2 * 300)
or the CONCATENATE function:
=CONCATENATE("The Diameter will increase like D = ", 1000 + (2 * 300))
I believe that most users would use the operator method. In both cases, you must enclosed any text strings in quotes.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.