Excel: Convert the character formula in a cell to the calculated value

Variable: the cell [fa] in which the text formula is located (set its coordinates to the first column of the first row, that is, A1) and output to the result cell [FB].
1. Enter the text formula to be calculated in [fa], such as "'= 100*100" or "100*100. Note that the first formula starts with single quotes.

2. In [FB], run the following command: insert | Name | definition |
Enter a function name such as "ABC" in the name field. The value is the name of the function required for later reference.

Enter "= evaluate" + reference position in the reference position field (directly enter its coordinate value and insert it into the left and right brackets), for example, "= vealuate (A1 )". A1 is the coordinate of [fa. Of course, you can use all positioning methods recognized by Excel in brackets.
OK

3. In [FB], enter "= ABC ";

4. Similar to other reference methods, you can reference the relative position in the cccv mode, or make other modifications on it, such as specifying the position where 4 homes are 5 inbound.

If the reference position in step 2nd does not directly enter the coordinate value, you may not be able to reference the relative position.