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
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
One way:
="the days you worked today are " & $A$6
In article <[email protected]>,
Jared <[email protected]> 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
="the days you worked today are(" & $A$6 & ")"
--
Gary's Student
"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
Great,
Now how do i do the same but in a formula?
entering a cell value in a formula?
='C:\Documents and Settings\Owner\Desktop\[April.xls]Month'!H7
but instead of "april.xls" i want to put $B$2
"Gary''s Student" wrote:
> ="the days you worked today are(" & $A$6 & ")"
>
> --
> Gary's Student
>
>
> "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
Whenever you want to construct a reference by splicing together bits of
strings use INDIRECT():
=INDIRECT("[" & $B$2 & "]Month!H7")
assuming that B2 contains the text April.xls
REMEMBER: This will not work if the target workbook is not open.
--
Gary's Student
"Jared" wrote:
> Great,
> Now how do i do the same but in a formula?
>
> entering a cell value in a formula?
>
> ='C:\Documents and Settings\Owner\Desktop\[April.xls]Month'!H7
>
> but instead of "april.xls" i want to put $B$2
>
> "Gary''s Student" wrote:
>
> > ="the days you worked today are(" & $A$6 & ")"
> >
> > --
> > Gary's Student
> >
> >
> > "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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks