| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
