Incorporating text into cell w/ formula?

[djarcadian]

I have this formula

=SUM(E22*0.5)+1

and want to incorporate it into a single cell along with text so i
will display like this:

Allow 2 hours for bid

The two, of course, being the sum of the formula.

How would I format this?

Thanks in advance! :

 

[Mark]

="Allow " & SUM(E22*0.5)+1 & " hours for bid"

 

[Gord Dibben]

="Allow " & E22*0.5 +1 & " hours for bid"

Note: the SUM function is not necessary.


Gord Dibben MS Excel MVP

 

[djarcadian]

Thanks guy!