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

D

Dave Peterson

Edit|Replace
what: Average(
with: =average(

As long as Average( only occurs at the beginning of each cell in your selected
area.

It'll screw up on cells like:

=if(a1=5,average(b1:b10),average(c1:c18))
 
J

Jason Morin

Assuming your "formulas" w/out equal signs are in column
A...

1. Insert this into row 1 of an open col. (say col. B)
and fill down:
="="&A1

2. Select col. B, copy it, and go to Edit > Paste Special
Value.
Click to expand...

3. Press Ctrl+H and fill in:

Find What: =
Replace With: =

HTH
Jason
Atlanta, GA
 
G

Gord Dibben

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
 
Top