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

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