text in a cell

[rob kessler]

I have a formula in a cell but I'd like for the word "less" to appear next to
the result of the formula in the cell. Can I do this? I can't figure out
how.

 

[Atishoo]

="Less" &" " & add your formula here

 

[Gord Dibben]

=A1+B1 & "less"

="less" & A1+B1

Or simply format the cell as Custom

="less "#,##0.00


Gord Dibben MS Excel MVP


On Mon, 19 Oct 2009 14:50:01 -0700, rob kessler <rob