Can I put a formula and text in the same cell in Excel?

S

shawn

I have a cell that I need to have text entered and a formula entered in the
same cell. I do not have room to separate the formula into another cell. If
there is a way to do this please explain the steps.

Thank you.
 
B

Bernie Deitrick

Shawn,

Sure, if you include the text in your formula:

="The sum of my sales were " & TEXT(SUM(A1:A10),"$0.00")

HTH,
Bernie
MS Excel MVP
 
Top