Thread: Parse formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Parse formula

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