Combine Cells With Text and a Number

1. Select the cell in which you want the combined data.
2. Type the formula, with text inside double quotes. For example: =”Due in ” & A3 & ” days” NOTE: To separate the text strings from the numbers, end or begin the text string with a space.
3. Press Enter to complete the formula.

To copy the actual value instead of the formula from the cell to another worksheet or workbook, you can convert the formula in its cell to its value by doing the following: Press F2 to edit the cell. Press F9, and then press ENTER.

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

How to do calculations in Excel. 1 Type the equal symbol (=) in a cell. This tells Excel that you are entering a formula, not just numbers. 2 Type the equation you want to calculate. For example, to add up 5 and 7, you type =5+7. 3 Press the Enter key to complete your calculation. Done!

Type the equal symbol (=) in a cell. This tells Excel that you are entering a formula, not just numbers. Type the equation you want to calculate. For example, to add up 5 and 7, you type =5+7

Here’s how: 1 Type the equal symbol (=) in a cell. This tells Excel that you are entering a formula, not just numbers. 2 Type the equation you want to calculate. For example, to add up 5 and 7, you type =5+7 3 Press the Enter key to complete your calculation. Done! More

Then, press ENTER, and Excel instantly calculates and displays the result of the formula. For example, when you type =12.99+16.99 in cell C5 and press ENTER, Excel calculates the result and displays 29.98 in that cell. The formula that you enter in a cell remains visible in the formula bar, and you can see it whenever that cell is selected.