A
alldreams
how could I add text to the end of a formula?
i.e. =A1/A2 "text"
i.e. =A1/A2 "text"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dan B
=(A1/A2)&" ""text"
That should work.
Dan
That should work.
Dan
D
Dan B
oops.... try this
=(A1/A2)&" "&"text"
=(A1/A2)&" "&"text"
Dan B said:=(A1/A2)&" ""text"
That should work.
Dan
P
Peo Sjoblom
=A1/A2&" text"&
D
Dave R.
=A1/A2&" text"
K
Ken Wright
You can just bury the space at the start of the text
=A1/A2&" text"
=A1/A2&" text"
G
Guest
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 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
2
2rrs
Try this:
=A1+A2+N("text")
=A1+A2+N("text")