Variable Naming

[Niebsmich]

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

 

[Vasant Nanavati]

Use the concatenate operator "&":

=B12&"apples"

--

Vasant

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)"

 

[niebsmich]

Thank you so much!

 

[Vasant Nanavati]

Glad to help!