Covert text to be a Formula

**macky1730** · 07-22-2010, 03:20 AM

is it possible to convert text from a cell to a formula from another cell.
Example:
Value in "A1" is word "concatenate"
Value in "A2" & "A3" is letters "A" & "B"
then in cell "A4" i want to make a formula that would look like this
A4=A1(A2,A3)
A4 = concatenate(A2,A3)
so the final value in A4 would be "AB"

please help

**DonkeyOte** · 07-22-2010, 03:33 AM

You would need to use VBA to some extent - ie utilise Evaluate either via old XLM call (Name), VBA or via 3rd party morefunc.xll

Given your use of XL2007 I'd be inclined to use a UDF (stored in a Module in VBE)

Function EvalString(strFormula as String)
    EvalString = Application.Caller.Parent.Evaluate(strFormula)
End Function

Your formula in A4 would be:

=EvalString(A1&"(A2,A3)")

Does that help ?

**macky1730** · 07-22-2010, 03:46 AM

i was hoping for a formula without using VBA

. anyway thanks

Covert text to be a Formula

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Covert text to be a Formula

Re: Covert text to be a Formula

Re: Covert text to be a Formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions