adding text to the end of a formula

L

Lodge

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?
 
J

Jim Cone

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



"Lodge" <[email protected]>
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank Formula 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
returning a text value using a formula 1
Searching the formula (not the value) for a text string 1
formula to add number comined with text 1
How can I use the same random number twice in the same formula? 2
Create a formula by joining text and the value from a formula 3
Countif formula perhaps 7

Top