View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
djarcadian djarcadian is offline
external usenet poster
 
Posts: 1
Default Incorporating text into cell w/ formula?


I have this formula

=SUM(E22*0.5)+1

and want to incorporate it into a single cell along with text so it
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! :)


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=570544