Current location - Recipe Complete Network - Complete cookbook of home-style dishes - Excel table problem, one input 2*3 (kitchen), the other display 6.
Excel table problem, one input 2*3 (kitchen), the other display 6.
Insert, name, definition, enter AAA

Reference position input

=EVALUATE(MID($A 1, 1,3))

Then enter it in B 1

=AAA

tie down

That depends on what your formula is, combined with functions such as substitute and replace, you can extract a pure formula based on text.

Use the macro table function EVALUATE to convert it into a computable formula.