If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Formulas and text in the same cell
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? |
#3
|
|||
|
|||
Formulas and text in the same cell
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? |
Thread Tools | |
Display Modes | |
|
|