Yes, you can achieve this by using the following steps:
- Select the cell where you want to display the result of the subtraction.
- Type the formula
Code:
=VALUE(cell1)-VALUE(cell2)
where "cell1" and "cell2" are the cells containing the values you want to subtract. - Press Enter to calculate the result.
The
VALUE function in Excel converts a text string that represents a number to a numeric value. By using this function, you can extract the numeric value from the cells that contain both a number and a letter.
For example, if you want to subtract the values in cells A1 and B1, you would type
Code:
=VALUE(A1)-VALUE(B1)
in the cell where you want to display the result.
After you press Enter, Excel will calculate the result of the subtraction and display it in the selected cell. If you want to display the result with the units, you can simply type them after the formula in the same cell.