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?

Text that includes data from a designated cell?
 

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

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=555907

Text that includes data from a designated cell?
 

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