Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Text, Date and Numbers together in a formula | Excel Discussion (Misc queries) | |||
Adding a Number and Formula Text and Evaluating | Excel Worksheet Functions | |||
Adding text to a formula | Excel Discussion (Misc queries) | |||
Formula for adding a comma in front of text in a cell | Excel Worksheet Functions | |||
Adding text to the result of a formula? | Excel Worksheet Functions |