Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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

Re: Adding Text to a formula

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

Thanks Dave

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.