Text Changing, based on data
 

I need a way, in Excel, to change the text in a statement automatically,
based on data.

For example, if I put a statement that states "You now have 25 tries
left"... the 25 may change to any number automatically, and probably is
pointed to a cell of some sort. But how do I make a formula that allows
the statement to stay the same, and the number just change
automatically?


--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: http://www.excelforum.com/member.php...o&userid=34133
View this thread: http://www.excelforum.com/showthread...hreadid=539019

Text Changing, based on data
 

="You now have " & text(a1,"#,##0") & " tries left"
or just
="You now have " & a1 & " tries left"
if you don't care about the formatting.



seanrigby wrote:

I need a way, in Excel, to change the text in a statement automatically,
based on data.

For example, if I put a statement that states "You now have 25 tries
left"... the 25 may change to any number automatically, and probably is
pointed to a cell of some sort. But how do I make a formula that allows
the statement to stay the same, and the number just change
automatically?

--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: http://www.excelforum.com/member.php...o&userid=34133
View this thread: http://www.excelforum.com/showthread...hreadid=539019

--

Dave Peterson

Text Changing, based on data
 

hi!

in A1: ="You have"&" "&B1&" "&"tries left"&"!"
in B1: =enter the value as you wish!

-via135



seanrigby Wrote:
I need a way, in Excel, to change the text in a statement automatically,
based on data.

For example, if I put a statement that states "You now have 25 tries
left"... the 25 may change to any number automatically, and probably is
pointed to a cell of some sort. But how do I make a formula that allows
the statement to stay the same, and the number just change
automatically?


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539019

Text Changing, based on data
 

Excellent! Works Great! Thanks!


--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: http://www.excelforum.com/member.php...o&userid=34133
View this thread: http://www.excelforum.com/showthread...hreadid=539019