Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

excel

vba

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?

like image 307
notnot Avatar asked Feb 09 '10 19:02

notnot


1 Answers

You have a couple of options:

& operator:

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

or CONCATENATE():

=CONCATENATE("blah blah ",A1," foobar ",B1)
like image 191
mechanical_meat Avatar answered Oct 21 '22 06:10

mechanical_meat