View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ognavtra ognavtra is offline
external usenet poster
 
Posts: 2
Default how do I substitute precedants in long excel formulas

i have generated long formulas (eg the sum of all variables in one column
multiplied by the variables in another column). is there a way to 'find &
replace' one set of precedants with another for a different column without
having to manually change all the precedant references one by one?