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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel How to add numbers in same cell? 2
Formula text in woorksheet cell 2
Excel VBA 1
Conditional formatting in Excel 2010 2
Formula help 1
Combining Text From Cells 3
If cell is blank automatically enter today's date in the same cell 21

Back
Top