ExcelBanter - text in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - text in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/245911-text-cell.html)

rob kessler

text in a cell

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

text in a cell

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

"rob kessler" wrote:

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.

Gord Dibben

text in a cell

=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
wrote:

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.

All times are GMT +1. The time now is 02:34 AM.