Referencing an Excel address within a cell, but also additional text

Question

I want to be able to insert a reference into a cell with arbitrary text around it.

ex. use a reference to cells A1, B1

  C1 => "blah blah <A1 text> foobar <B1 text>"

Is there any way to do something like this while still maintaining the references?

Answer 1

You have a couple of options:

& operator:

="blah blah " & A1 & " foobar " & B1

or CONCATENATE():

=CONCATENATE("blah blah ",A1," foobar ",B1)

Answer 2

=CONCATENATE("blah blah ", A1, " foobar ", B1)

Put the above formula in cell C1.