# Solved Make excel to calculate something in a cell having text too. February 22, 2012 at 23:34:18
Specs: Windows XP
 Normally if we enter =1000 + 250 in a cell, we get 1250 in return. But if i have the following text as well as the mathematical expression in a single cell ;"The Diameter will increase like D = 1000 + (2 * 300) = 1600"I want the excel to calculate the expression by itself when i hit enter after writing the above expression in that cell as here i had manually calculated and had written the result.Any Help ? See More: Make excel to calculate something in a cell having text too.

#1 February 23, 2012 at 01:46:37
 You can use either the Concatenate Operator, the ampersand:="The Diameter will increase like D = " & 1000 + (2 * 300)or the CONCATENATE function:=CONCATENATE("The Diameter will increase like D = ", 1000 + (2 * 300))I believe that most users would use the operator method. In both cases, you must enclosed any text strings in quotes.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#2
February 23, 2012 at 02:49:44
 So far so good. Thank you very much. But it cannot fully satisfy the needs. I want it to show "The Diameter will increase like D = 1000 + (2 * 300) = 1600"wherein the solution given shows only The Diameter will increase like D = 1600

Report •

#3
February 23, 2012 at 02:57:39
 Thank you once again. But i got it.="The Diameter will increase like D =1000+(2*500)= "&1000+(2*500)This will give the exact statement.

Report •
Related Solutions 