Thanks for the info, Anthony.

Epinn

"Anthony D" wrote in message ...
Hi Epinn,

Seems to be ok as a function in the Visual Basic Editor, for example:

Function csum(i)
csum = Evaluate(Application.WorksheetFunction.Substitute( i, ",", "+"))
End Function

Then in b1: =csum(a1)

Anthony


"Epinn" wrote:

Does EVALUATE( ) still exist in V. 2003? I couldn't find it from Excel Help. Seeing that DATEDIF can't be found via F1 but still alive and kicking, I need to hear about EVALUATE ( ) for sure although I think I see something like "undefined." If it is not available, what do we use now? I found it from the following writeup. By the way, does naming a formula goes thru the same steps as naming a range on a worksheet? InsertNameDefine?

************************************************** ********************

Created by David Hager
To add comma delimited values in a cell (such as 1,2,11,4 in cell A1) to
the right of the cell containing the string, highlight cell B1 (for this
case) and create the following defined name formula (called "csum"):

=EVALUATE(SUBSTITUTE(A1,",","+"))

Then, type =csum in B1 to obtain the result (18, in this case).

************************************************** *************

Thank you for your help.

Epinn