Evaluation of a text string as a function

%3CLINGO-SUB%20id%3D%22lingo-sub-1942956%22%20slang%3D%22en-US%22%3EEvaluation%20of%20a%20text%20string%20as%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1942956%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20there%20exist%20an%20Excel%20function%20that%20will%20evaluate%20a%20(syntactically%20correct)%20text%20string%20as%20a%20formula%3F%20%26nbsp%3BA%20simple%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet's%20say%20that%20I%20have%20the%20text%20string%20'%3DA5%3C%2FP%3E%3CP%3EDoes%20there%20exist%20a%20way%20that%20I%20can%20get%20Excel%20to%20evaluate%20it%20as%20%3DA5%2C%20thus%20returning%20the%20value%20of%20the%20contents%20of%20cell%20A5%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1942956%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1943009%22%20slang%3D%22en-US%22%3ERe%3A%20Evaluation%20of%20a%20text%20string%20as%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1943009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F886388%22%20target%3D%22_blank%22%3E%40Mark_Proulx%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20found%20it...the%20INDIRECT%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Does there exist an Excel function that will evaluate a (syntactically correct) text string as a formula?  A simple example:

 

Let's say that I have the text string '=A5

Does there exist a way that I can get Excel to evaluate it as =A5, thus returning the value of the contents of cell A5?

2 Replies

@Mark_Proulx 

 

Just found it...the INDIRECT function.

@Mark_Proulx 

If I understand correctly about the translation, this could help you.

 

Example:

is J10 text with number "M12" then cell with formula "= RIGHT (J10,2)" only shows the "12".

If only the numbers are presented like that.

If the number first and then the text, then use the command LEFT instead of RIGHT.

 

If that's not what you wanted or what you can't use, please just ignore it.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.