Re: how does one convert text to a formula "average(A:A)" to =average(

You can employ a UDF.

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

With the text average(A:A) in B1 enter

=EvalCell(B1) in C1

Would seem to me however that typing an = sign would be easier than
entering/copying a bunch of formulas.

Unless you have the text pre-entered and are looking to change to a formula.


Gord Dibben Excel MVP

On Wed, 13 Apr 2005 16:52:04 -0700, "phshirk"
<phshirk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Would prefer not having to enter = manually in each cell.

.

Relevant Pages

  • Re: Excel Addin in VB.NET 2k3 - how to return #N/A
    ... > I just created a UDF in VB.Net say ... > If TextOnly.GetType.Equals(Gettype(String)) then Return "This is a String" ... Prev by Date: ...
    (microsoft.public.office.developer.com.add_ins)
  • Re: Group data by UK financial years
    ... As far Fiscal Years are concerned, you could adapt ... your own UDF based on the following one: ... Function FYAs String ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Excel Addin in VB.NET 2k3 - how to return #N/A
    ... I just created a UDF in VB.Net say ... If TextOnly.GetType.Equals(Gettype(String)) then Return "This is a String" ... I want my UDF to return #N/A (as a real Excel error) ie not a ... Prev by Date: ...
    (microsoft.public.office.developer.com.add_ins)
  • Re: Help with function/cond. formatting
    ... Function EvalCell(RefCell As String) ... EvalCell = (RefCell) ... >EvalCell = Evaluate ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: concatenated text to formula
    ... Then copy/paste this UDF into a module. ... Function EvalCell(RefCell As String) ... EvalCell = Evaluate ... Usage is =EvalCell(cellref) where cellref is the cell with the above text. ...
    (microsoft.public.excel.misc)