Incorporating text into cell w/ formula?

D

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! :
 
G

Gord Dibben

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

Note: the SUM function is not necessary.


Gord Dibben MS Excel MVP
 
Top