Text that includes data from a designated cell?

B

Blades

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?
 
D

Dave Peterson

And if you wanted it formatted:

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