Formulas and text in the same cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
Hello, everyone,

I'm using a SUM function in a cell to add the content of two ranges in
Click to expand...
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."
 
Back
Top