Does EVALUATE( ) still exist in V. 2003?
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
|