On Tue, 1 Mar 2005 13:59:40 +0100, "Jos Vens" wrote:

Hi,

does someone know if it's possible and how it can be done to use a string in
formula like this

cell A1 contains Average
cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1)

thanks
Jos Vens


Download MOREFUNC.XLL from http://xcell05.free.fr/ and use the EVAL function.
It accepts strings so, in your instance, the function would read:

=EVAL(A1&"(C1:F1)")


--ron