ExcelBanter - adding text to the end of a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - adding text to the end of a formula (https://www.excelbanter.com/excel-worksheet-functions/235065-adding-text-end-formula.html)

Lodge

adding text to the end of a formula

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?

Jim Cone[_2_]

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?

All times are GMT +1. The time now is 04:44 PM.