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

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

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

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

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