在单元格中引用Excel地址，也可以引用其他文本

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

使用对细胞A1 B1的引用

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

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

有什么方法在保持引用的同时做这样的事情吗?

2 个解决方案

#1

You have a couple of options:

你有几个选择:

& operator:

&运算符:

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

or CONCATENATE():

或连接():

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

#2

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

Put the above formula in cell C1.

将上述公式放在单元格C1中。