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?