adding text at the end of a formula

  • Thread starter Thread starter alldreams
  • Start date Start date
A

alldreams

how could I add text to the end of a formula?
i.e. =A1/A2 "text"
 
You can just bury the space at the start of the text

=A1/A2&" text"
 
alldreams
You might need to format your number with a TEXT function. The number format for the cell will not apply any more because your formula is returning a text string

example
=TEXT(A1/A2,"0.00")&" text

Good Luck
Mark Graesse
(e-mail address removed)

----- alldreams wrote: ----

how could I add text to the end of a formula
i.e. =A1/A2 "text
 
You must log in or register to reply here.

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

Changing function name in formula 17
Formula 5
Add number before text that matches criteria 3
adding text to the end of a formula 1
Displaying Cell Formulas (without using Tools/Options/View-Formula 6
Searching the formula (not the value) for a text string 1
Concantenate which keeps bold of some parts. 5
Comparison of columns using Conditional Formatting 3

Back
Top