software

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 quot;You now have 25 tries
leftquot;... 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: www.excelforum.com/member.php...oamp;userid=34133
View this thread: www.excelforum.com/showthread...hreadid=539019=quot;You now have quot; amp; text(a1,quot;#,##0quot;) amp; quot; tries leftquot;
or just
=quot;You now have quot; amp; a1 amp; quot; tries leftquot;
if you don't care about the formatting.
seanrigby wrote:
gt;
gt; I need a way, in Excel, to change the text in a statement automatically,
gt; based on data.
gt;
gt; For example, if I put a statement that states quot;You now have 25 tries
gt; leftquot;... the 25 may change to any number automatically, and probably is
gt; pointed to a cell of some sort. But how do I make a formula that allows
gt; the statement to stay the same, and the number just change
gt; automatically?
gt;
gt; --
gt; seanrigby
gt; ------------------------------------------------------------------------
gt; seanrigby's Profile: www.excelforum.com/member.php...oamp;userid=34133
gt; View this thread: www.excelforum.com/showthread...hreadid=539019

--

Dave Peterson


hi!

in A1: =quot;You havequot;amp;quot; quot;amp;B1amp;quot; quot;amp;quot;tries leftquot;amp;quot;!quot;
in B1: =enter the value as you wish!

-via135
seanrigby Wrote:
gt; I need a way, in Excel, to change the text in a statement automatically,
gt; based on data.
gt;
gt; For example, if I put a statement that states quot;You now have 25 tries
gt; leftquot;... the 25 may change to any number automatically, and probably is
gt; pointed to a cell of some sort. But how do I make a formula that allows
gt; the statement to stay the same, and the number just change
gt; automatically?--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=539019
Excellent! Works Great! Thanks!--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: www.excelforum.com/member.php...oamp;userid=34133
View this thread: www.excelforum.com/showthread...hreadid=539019