0
Here is an example:
="Three to the fifth power is " & POWER(3, 5) & "."
Wiki User
∙ 10y ago
Anonymous
heavy and carved and glit
Add your answer:
Earn +20 pts
How you can give formula in a cell excel in which text is already there?
If you have a cell the currently holds the text "friends," and you want it to combine a foumula and text in the same cell, here's an example: In cell A1 enter 23 (the number of friends you have). In cell A2 enter the following formula: ="You have " & A1 "friends." [You have 23 friends.] When you change the number in A1, you will see the number change in A2.
What is the chemical formula for sodium and phosphourous when they combine?
Sodium and phosphorus form sodium phosphide when they combine. The chemical formula for sodium phosphide is Na3P.
What formula do you get when you combine berllium and nitrogen?
Be3N2
Can text be entered in the formula bar?
Yes, you can type text into the Formula Bar.
What formula do you get when you combine the elements chlorine and magnesium?
The chemical formula of magnesium chloride is MgCl2.
When Al3 and O2- combine ionically what is the formula?
Al2O3
Does the CONCATENATE function in Excel require a text argument?
Normally yes, but it will actually take numbers and combine them into a text string.
Can you combine cell references and functions into one formula?
Yes.
What is the formula for calcium and nitrogen combine?
Tricalcium dinitride: Ca3N2.
How do you combine two MID functions in an Excel String Formula?
You could use the CONCATENATE function or the & operator. The following two formulas will do the exact same thing. They both use the MID function to extract two pieces of text and then combine them into one piece of text. =CONCATENATE( MID( A2, 2, 3 ), MID( A3, 2, 4 ) ) =MID( A2, 2, 3 ) & MID( A3, 2, 4 )
What is the chemical formula of the compound that forms when sodium and chloride combine?
NaCl
What is the chemical formula of the compound found when helium and oxygen combine?
water
