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 ,
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

="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