How to change Multiple cell formulas at once

[Sri_33]

Book1
	B	C	D	E	F	G	H	I	J	K	L
1		A	Total	B	Total	C	Total	D	Total	E	Total
2	1	23	0.002649213		#DIV/0!		#DIV/0!		#DIV/0!		#DIV/0!
3	2	44
4	3	52
5	4	0
6	5	0
Sheet1

Cell Formulas
Range	Formula
D2,L2,J2,H2,F2	D2	=AVERAGE(C2:C4)/31/21/C2

Hello all, please let me know if there is any way that we can change multiple cell formulas at once
In the above example i wanna change green highlighted cell formulas from the format " average(x2:x4)/31/21/x2" to "average(x2:x4)/x2"
Thanks in advance.

 

[Joe4]

Sure, just highlight all the sections you want to apply it to, and then do a Find/Replace, replacing /31/21 with nothing.
That should remove that from all those formula, so you end up with what you want.

 

[Sri_33]

Sure, just highlight all the sections you want to apply it to, and then do a Find/Replace, replacing /31/21 with nothing.
That should remove that from all those formula, so you end up with what you want.

Awesome thank you

 

[Sri_33]

Sure, just highlight all the sections you want to apply it to, and then do a Find/Replace, replacing /31/21 with nothing.
That should remove that from all those formula, so you end up with what you want.

What if there is "*" in place of "/" that means, what if i need to replace "*31/21/x2" to "/x2"

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[Sri_33]

You are welcome.
Glad I was able to help!

Hi, pls help me with the above doubt

 

[Joe4]

What if there is "*" in place of "/" that means, what if i need to replace "*31/21/x2" to "/x2"

Is there always a ")" before the "*"?
If so, then just replace )*31/21 with )

 

[Sri_33]

Is there always a ")" before the "*"?
If so, then just replace )*31/21 with )

Awesome, thank you once again

 

[Joe4]

You are welcome.