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

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 s开发者_如何学运维omething like this while still maintaining the references?

You have a couple of options:

& operator:

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

or CONCATENATE():

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

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

Put the above formula in cell C1.