0
What else can I help you with?
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 formula for calcium and nitrogen combine?
The chemical formula for calcium nitride, which is formed when calcium and nitrogen combine, is Ca3N2.
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
What is the chemical formula of the compound that forms when sodium and chloride combine?
When sodium and chloride combine, they form sodium chloride, which has the chemical formula NaCl.
Can text be entered in the formula bar?
Yes, you can type text into the Formula Bar.
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.
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 found when helium and oxygen combine?
water
In Excel can the cell and the Formula Bar be used to copy text to an adjacent cell?
Yes you can copy text from a cell or from the Formula Bar and then paste into other cells.
Which operator could be used to combine text from multiple cells into one cell?
ampersand(&) operator
