Thread: Display text and use a formula in 1 box
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Desert Piranha[_8_] Desert Piranha[_8_] is offline
external usenet poster
  
Posts: 1
Default Display text and use a formula in 1 box

Eric Wrote:
I need to be able to have text ("year end results") displayed then the
answer
from my formula. how do i do this?
Hi Eric,
Another way,

'="year end results" & " " & A9+A10


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=490498

Reply With QuoteReply With Quote