| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mixing text and formulas in the same cell
I would like to mix a formula with text in the same cell, something like
Client Name & sum(A1:C2) Any help would be greatly appreciated. Thanks, John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mixing text and formulas in the same cell
Where is the cliend name stored. Assuming it is in A10 you could do soemthing
like this... =A10 & " " & sum(A1:C3) or ="John Smith " & Sum(A1:C3) Note that when you add the text the cell is no longer numeric so you cna not do any further calculations against it... -- HTH... Jim Thomlinson "johnu" wrote: I would like to mix a formula with text in the same cell, something like Client Name & sum(A1:C2) Any help would be greatly appreciated. Thanks, John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mixing text and formulas in the same cell
= "Client Name "&sum(A1:C2)
The quote marks are used to delimit a text string. -- David Biddulph "johnu" wrote in message ... I would like to mix a formula with text in the same cell, something like "Client Name & sum(A1:C2)" Any help would be greatly appreciated. Thanks, John |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mixing text and formulas in the same cell
Am Tue, 16 Sep 2008 12:58:15 -0700 schrieb johnu:
I would like to mix a formula with text in the same cell, something like Client Name & sum(A1:C2) Any help would be greatly appreciated. ="Client Name " & sum(a1:c2) & " suffix" Kind regards, Markus |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mixing text and formulas in the same cell
A couple mo
=A1&": "&text(sum(a1:c2),"$#,##0.00") or ="Client Name: "&text(sum(a1:c2),"$#,##0.00") johnu wrote: I would like to mix a formula with text in the same cell, something like Client Name & sum(A1:C2) Any help would be greatly appreciated. Thanks, John -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mixing text and alpha in sumproduct arrays | Excel Worksheet Functions | |||
| mixing up a list | Excel Discussion (Misc queries) | |||
| Mixing up the arguments | Excel Worksheet Functions | |||
| mixing text and formulae in same cell | Excel Worksheet Functions | |||
| Mixing Font Sizes In A Cell Formula | Excel Worksheet Functions | |||
Linear Mode
