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

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

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))



phshirk wrote:

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

--

Dave Peterson

excel formulas start with =

--
Don Guillett
SalesAid Software

"phshirk" wrote in message
...
Would prefer not having to enter = manually in each cell.

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.

3. Press Ctrl+H and fill in:

Find What: =
Replace With: =

HTH
Jason
Atlanta, GA


-----Original Message-----
Would prefer not having to enter = manually in each cell.
.

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"
wrote:

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