In the opening Find and Replace dialog box, type = into Find what box, type a space into Replace with box, and then click the Replace All button. Note: You can also open the Find and Replace dialog box with pressing the Ctrl + H keys simultaneously.Ģ. Select the range in which you will copy the formulas, and select Range H1:H6 in our case, and then click Home > Find & Select > Replace. To prevent formula references from changing during copying, we can slightly modify formulas and then copy.
