View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default How do i add a cell value in a sentence without using 2 cells?

One way:

="the days you worked today are " & $A$6

In article ,
Jared wrote:

If i want to write a sentence but with a cell value inside, how do i input it
so the value of the cell is shown and not the reference?

example: the days you worked today are ($A$6)

i need it to be in one cell and not two seperate cells