Text that includes data from a designated cell?

Hi,

I want to write a short sentance that includes data from a cell on my
spreadsheet, is there any way of doing this?

for example I want to say;

"The number of women giving birth this year is (the value in cell C1)"

Can anyone help?

="The number of women giving birth this year is" & C1

hope this helps

And if you wanted it formatted:

="The number of women giving birth this year is " & text(C1,"#,##0") & "."

Blades wrote:
>
> Hi,
>
> I want to write a short sentance that includes data from a cell on my
> spreadsheet, is there any way of doing this?
>
> for example I want to say;
>
> "The number of women giving birth this year is (the value in cell C1)"
>
> Can anyone help?

--

Dave Peterson