Variable Naming

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to reference a cell in excel that has a character string in it, and when I reference it, I want to add letters to change the printed words. For instance, cell B12 has a value of "Red" and in cell B14, I want to make a formula that would reference B12, print that out, but add "Apples" for instance. I wonder if it is something like this in cell B14...."=B12(apples)

Thanks
 
Use the concatenate operator "&":

=B12&"apples"

--

Vasant


Niebsmich said:
I want to reference a cell in excel that has a character string in it, and
Click to expand...
when I reference it, I want to add letters to change the printed words. For
instance, cell B12 has a value of "Red" and in cell B14, I want to make a
formula that would reference B12, print that out, but add "Apples" for
instance. I wonder if it is something like this in cell
B14...."=B12(apples)"
 
Back
Top