One way:

Change your formula to

=C10+D10+E10

and choose Format/Cells/Number/Custom

"Text:"* General

Note: The space between * and General is critical. You can replace
General with another number format.

Note 2: This will convert your value from Text to a Number, and formulas
won't see the "Text:" part.

In article ,
"L/P" wrote:

I know how to add text to a formula but not sure how/if I can get the
results to right justify while keeping the text left justified.

Ex.

="Total:" &C10+D10+E10

Would like Total: to stay on left of cell and have results on right
formatted as currency.

Total: $4567.87

Can I "split" a single cell?


Thanks,

L.