cell value plus text
try this in cell N81
=C81&" oranges" or
=C81&" "&C1
--
Hope this is helpful
Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.
Thank You
cheers, francis
"Deanna" wrote:
I would like to know how to get the value from one cell (C81) entered into
another cell (N81) and then have text after that value. For example, if
C81=2, I need N81 to have 2 plus text (2 oranges). If this is not possible,
I do have the text in the first row and could reference that cell, but then
would need to know how to string the two cells of text together (i.e. C81=2
and C1=oranges so N81=2 oranges).
|