View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default cell value plus text

Try one of these:

=C81&" oranges"

Or, using a cell to hold oranges:

C1 = oranges

=C81&" "&C1

--
Biff
Microsoft Excel MVP


"Deanna" wrote in message
...
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).