Browse » Home
Wednesday, May 25, 2011
How Can I Put Text a Formula Into the Same Cell in an Excel Spreadsheet?
Test the theory
1. Open a new workbook or spreadsheet and click in cell A1. Type the number 2.
2. Click in cell A2 and type the number 2 there.
3. Click in cell A3 and type:=SUM(A1,B1)
4. Press 'Enter' or click elsewhere on the spreadsheet and the cell will show the number 4 (as this is the sum of 2 2). Note that the function bar (the long white strip next to the 'fx' symbol) still shows the formula '=SUM(A1,B1).'
5. In the function bar, place your cursor after the equal symbol and type:'The sum of 2 2 is 'Include both quotation marks and the space after 'is' but no other spaces.The complete formula should read='The sum of 2 2 is 'SUM(A1,B1)
6. Click anywhere else on the table and cell A3 will now show: 'The sum of 2 2 is 4.'