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.