View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
porter444 porter444 is offline
external usenet poster
 
Posts: 73
Default Combine text and formula

="ROI ="&C37

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"charles" wrote:

I'm trying to display text and the results of a formula. In this case, the
text comes first, and the formula result after.

Want the cell to read, "ROI = 4.99", with 4.99 the result of =quotient(N41,
C37)

--
thanks,

charles