Formulas and text in the same cell

Hello, everyone,

I'm using a SUM function in a cell to add the content of two ranges in different part of my worksheet, but I would like to be able to include text in same cell so it looked something like "Total 99 pcs." Right now I am placing the text in adjacent cells and because of the layout of the document I have something like "Total 99 pcs."

Any suggestion?

Hi
try something like
="Total " & SUM(A1:A100) & " pcs."

--
Regards
Frank Kabel
Frankfurt, Germany


Saul N-L wrote:
Hello, everyone,

I'm using a SUM function in a cell to add the content of two ranges
in different part of my worksheet, but I would like to be able to
include text in same cell so it looked something like "Total 99 pcs."
Right now I am placing the text in adjacent cells and because of the
layout of the document I have something like "Total 99
pcs."

Any suggestion?

Try Format Number Custom "Total" #### "pcs." and put your regular
formula in the cell.

Vaya con Dios,
Chuck, CABGx3



"Saul N-L" wrote in message
...
Hello, everyone,

I'm using a SUM function in a cell to add the content of two ranges in
different part of my worksheet, but I would like to be able to include text
in same cell so it looked something like "Total 99 pcs." Right now I am
placing the text in adjacent cells and because of the layout of the document
I have something like "Total 99 pcs."

Any suggestion?