How to replace part of the code?

[Greenlee]

I have formula
I want to replace all H to H9 how do I do that ? cause its to much work to replace 10000 formulas

=((E28/H12)*(F28*H12))
=((E29/H13)*(F29*H13))
=((E30/H14)*(F30*H14))

Much appreciate in advance

 

[Rick Rothstein]

I have formula
I want to replace all H to H9 how do I do that ? cause its to much work to replace 10000 formulas

=((E28/H12)*(F28*H12))
=((E29/H13)*(F29*H13))
=((E30/H14)*(F30*H14))

Much appreciate in advance

As long as your Column H row references are all two digits long, select the cell or cells where you want to make this change, press CTRL+H to bring up the Repace dialog box, put H?? (an H followed by two question marks) in the "Find what" field, put H9 in the "Replace with" field, click the "Options>>" button and make sure the "Match entire cell contents" check box is not checked, then press "Replace All".

 

[Greenlee]

Really appreciate your help It worked as charm!

Have a nice day!

 

[István Hirsch]

…Or, if the numbers following H have more than 2 digits (H1234 etc.), do what Rick suggested, with „H*)” in the „Find what” box and „H9)” in the „Replace with” box (without quotes).