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
donaldb@281.com
"phshirk" <phshirk@discussions.microsoft.com> wrote in message
news:320679BE-CECD-4D30-98A7-F46894E06F2B@microsoft.com...
> 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"
<phshirk@discussions.microsoft.com> wrote:

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