Add text to formula?

  • Thread starter Thread starter Pete_UK
  • Start date Start date
P

Pete_UK

Have your tried doing this:

="You:Computer = "&COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
Lost*")

?

Hope this helps.

Pete
 
I have this formula kindly given to me in one of these Excel ngs:

=COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You Lost*")

The challenge is that any custom text I add to the cell formatting
doesn't show up in the cell. Would it be possible to add something
like this text below to the above (but also including line breaks)?:

****************************************************************
Score
---------
You:Computer =
Formula result of: =COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
Lost*")
****************************************************************

Thanks! :oD
 
Yes, you can do this:

="You:Computer = "&CHAR(10)&COUNTIF(E:E,"You Won!*")&":"&COUNTIF
(E:E,"You Lost*")

You need to format the cell to Wrap Text, and you might need to adjust
the row height manually to see both.

Basically, the CHAR(10) is equivalent to <new line>.

Hope this helps.

Pete
 
Have your tried doing this:

="You:Computer = "&COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
Lost*")
Click to expand...

Close enough for now, thanks much. Much better than what I had up
till now which is a separate cell for the "title" of the score ratio.

Just out of curiousity, is there no way to get in "carriage returns"
in there, is there? <g>

Thanks! :oD
 
Yes, you can do this:

="You:Computer = "&CHAR(10)&COUNTIF(E:E,"You Won!*")&":"&COUNTIF
(E:E,"You Lost*")

You need to format the cell to Wrap Text, and you might need to adjust
the row height manually to see both.

Basically, the CHAR(10) is equivalent to <new line>.

Hope this helps.
Click to expand...

Very kewl! Will give this a try later on tonight. Thanks! :oD
 
Back
Top