开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜