cell value plus text

  • Thread starter Thread starter Deanna
  • Start date Start date
D

Deanna

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).
 
Try one of these:

=C81&" oranges"

Or, using a cell to hold oranges:

C1 = oranges

=C81&" "&C1
 
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
 
You can also use Custom Formatting  Format/Cells/Number Custom; Insert
the format as 0 " oranges".
This will show "oranges", but as it holds a numerical value, it means
you can calculate with it as normal.
Click to expand...

Dear mdmackillop
A very nice solution. while the cell is numeric and you can conduct
the calculation it also shows the text you want.
 
Back
Top