adding text at the end of a formula

[alldreams]

how could I add text to the end of a formula?
i.e. =A1/A2 "text"

 

[Dan B]

=(A1/A2)&" ""text"

That should work.

Dan

 

[Dan B]

oops.... try this
=(A1/A2)&" "&"text"

=(A1/A2)&" ""text"

That should work.

Dan

 

[Peo Sjoblom]

=A1/A2&" text"&

 

[Dave R.]

=A1/A2&" text"

 

[Ken Wright]

You can just bury the space at the start of the text

=A1/A2&" text"

 

[Mark Graesser]

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

 

[2rrs]

Try this:
=A1+A2+N("text")