Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Microsof Excel: How do I get the result of a formula, to reflect in a sentence? For example: I have a calculation in cell A1. Now in A2, I have the following sentence: "The result is.... and is reflected on the schedule of differences" . I want the result from A1 to reflect in this sentence where the ...... is.

share|improve this question

You can use & to add strings and values together. For example:

= "The result is " & A1 & " and is reflected on the schedule of differences"
share|improve this answer
1  
Depending on how you want to show the number you might also need TEXT, FIXED or ROUND function around A1 e.g. for 2 decimal places FIXED(A1,2) – barry houdini Apr 9 '13 at 16:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.