| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show text data in excel pivot table | Excel Discussion (Misc queries) | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
