Hi, my problem is that the find finds the number in the data portion of the
spreadsheet and NOT in the formula. How do I get to the formula to edit it?

"Peo Sjoblom" wrote:

Works fine for me, btw you can simplify the formula


=SUM(E4*E5,F4*F5,G4*G5)


I replace the 3 with 4 and worked fine. Just select the formula(s) and do
ctrl + h and put 3 in find what and 5 in replace with

--


Regards,


Peo Sjoblom


"Marty" wrote in message
...
I have created a simple formula but its long. How do I edit (find &
replace)
pieces of the formula. For example, my formula is
=sum(e3*e5)+(f3*f5)+(g3*g5)+....., I want to do a find on 3 and replace it
with another number. Can that be done and if yes, how.
Another way of looking at the formula is - row 3 has different prices for
columns e thru bba. Rows 5 thru 225 have a number of items. I need to
multiply the prices by the items for each row/column and get a total for
each
row. The prices are constant and always in row 3 while the items go from
row
5 thru 225.
I hope that someone understands what I am trying to do and can help me.