Text Changing, based on data

S

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

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.
 
V

via135

hi!

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

-via135
 
Top