hi, i am hoping someone has a quick or pre-prepared way to do this.
i need to essentially find and replace udf's and the complication is rearranging the parameters in the udf's into a new formula structure.
so my question, is there an easy way to extract a parameter (or all parameters) from a function?
for example, if you had =SUM(A1,A2,A3:A6) you would return 'A1' as the first parameter, 'A2' as the second and 'A3:A6' as the third.
Obviously it gets complicated when you nest functions such as =SUM(IF(A2=1,0,A1),A3) etc and the if() function would be parameter 1.
any help appreciated,
cheers.