Adding Text to a formula

Posted by Mo on December 30, 2000 6:16 AM

I have a formula that I use. Once its given me the results I want to add some text in some instances. I want the text to appear on the cell. Is there a way to do this. Example the formula returns good. after that that I want to add up my own words .
Thank you

Posted by Dave on December 30, 2000 7:11 AM

Hi Mo

Here's a few ways that may suit you. Suppose your formula that returns "Good", is cell refering to A1

1. =A1 & " Hello"

2. ="Good" & CONCATENATE(" Hello")

3. Insert>Comment (Good for memory jogs)

4. =A1& N("Hello") This one is not really suited to text though, as it returns 0 and can only be seen by clicking in the cell.

Hope one suits.

Dave
OzGrid Business Applications

Posted by Mo on December 30, 2000 6:01 PM

Thanks Dave