Don,
I wrote a function to extract arguments from a formula
(
http://www.vangelder.co.nz/excel/index.html)
You might be able to change the line which reads:
Application.International(xlListSeparator) to use a "+" instead.
Rob
"Don Guillett" wrote in message
...
Also posted on L list
How can I turn this
=SUM(IU6+IU16+IU28+IU57*2+IU99*2)
into
=iu6 better yet = a6 which is text
=iu16
=iu28
=iu57*2
=iu99*2
preferable turn the last two into
=a57 (which is TEXT) and *2 in text
like where a57 is item4 in text
=item4 *2
--
Don Guillett
SalesAid Software