How to Convert a Formula to a Value?

Conversion of formula to value is possible in different ways. But, we'd go through one of the simplest methods to make such conversion. First, we need a data that looks like this:


data table conversion

1. Mark the cells with formulas, and then press CTRL + C.

2. Go to an empty cell or spreadsheet, right click on it (1), and then choose paste special (2). Now choose the paste values (3).

paste special values