In the function bar, place your cursor after the equal symbol of your =SUM(A1,A2) formula. Showing Text in the Same Cell as a Formula The function bar (the long white strip next to the 'fx' symbol) will show the formula The cell A4 now shows a number “6” - the sum of 3+3 in the two cells. Press the 'Enter' key or click anywhere else on the spreadsheet. Now click in cell A2 and type the number 3 in there. Speech, or quotation marks are used to let Excel know that you want what’s inside them to be treated as text, and an ampersand, the “&” symbol, is used to connect your text to the formula.Ĭlick in cell A1 of a spread sheet and type the number 3.
This is a step by step guide showing you how to make an Excel cell show text and formula results at the same time. You can get put text and a formula into the same cell of an Excel spreadsheet quite easily, which can allow you to produce very polished looking spreadsheets and reports.
