Text Changing, based on data

[seanrigby]

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]

hi!

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

-via135

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?

[Dave Peterson]

="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

[seanrigby]

Excellent! Works Great! Thanks!