# How to replace part of the code?

#### Greenlee

##### New Member
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))

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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))

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".

Really appreciate your help It worked as charm!

Have a nice day!

…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).

Replies
11
Views
385
Replies
10
Views
695
Replies
19
Views
329
Replies
7
Views
204
Replies
8
Views
203

1,202,984
Messages
6,052,910
Members
444,612
Latest member
FajnaAli

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back