Here is an example:
="Three to the fifth power is " & POWER(3, 5) & "."
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.
The chemical formula for calcium nitride, which is formed when calcium and nitrogen combine, is Ca3N2.
Sodium and phosphorus form sodium phosphide when they combine. The chemical formula for sodium phosphide is Na3P.
Be3N2
When sodium and chloride combine, they form sodium chloride, which has the chemical formula NaCl.
Yes, you can type text into the Formula Bar.
Normally yes, but it will actually take numbers and combine them into a text string.
Yes.
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 )
water
Yes you can copy text from a cell or from the Formula Bar and then paste into other cells.
ampersand(&) operator