View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default adding text to the end of a formula

=D4+D5 & "+"
-or-
Format the cell... 0"+"
--
Jim Cone
Portland, Oregon USA



"Lodge"
wrote in message
Does anyone know how I can add text to the end of a formula in the same cell?
For example, the formula I have will compute a list of numbers and display
the total in the cell...I would like at the end of this number for the
character "+" to follow the number. Any help?