Formulas and text in the same cell

S

Saul N-L

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?
 
C

CLR

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The sum of the same function that is used for a range of cells 2
Please help with last formula for order form. 1
dragging formulas acros adjacent cells 3
A useful AVERAGE calculation without using the built-in AVERAGE function 3
Need formula to automatically populate Sheet 2 cells with same content as Sheet 1 1
ignoring text data in a cell when summing values in the same cell 2
Mapping integers to strings 6
Total cells of one column based on the values in another column? 10

Top