# Find and replace in formulas

1. ## Find and replace in formulas

Hello

I have various formulas (such as: =(D3-\$E\$3)/\$E\$3 )
which continues for each row (IE next row 3 is replaced with 4 etc)

I have made som errors when I made the formulas and therefore I have the following questions:

1. Is it possible to find and replace all E's with another letter (F in my case). I haven't been able to resolve this, when it has to be done inside formulas?
The optimal would be if I could set 'Display formulas' under tools, and find and replace in the formulas displayed.

2. Is there a smart way of swapping D3 with E3 for all formulas? (So the result will be: =(\$E\$3-D3)/\$E\$3 and etc for all formulas)

2. ## Re: Find and replace in formulas

Hi,

Something like this?

3. ## Re: Find and replace in formulas

Of course :-), Thanks !

No idea how I overlooked that

However I want to change the order in all my formulas, so that the next row will be
=(\$E\$4-D4)/\$E\$4

I have about 100 rows, so it's alot of work if i have to search and replace for each row.

I also drag the formulas the continue so that the next formula is =(\$E\$4-E4)/\$E\$4, therefore removing the \$ is not the solution.

4. ## Re: Find and replace in formulas

Hi,

Take a look here

http://excel.tips.net/Pages/T003067_...a_Pattern.html

Does that help?

5. ## Re: Find and replace in formulas

Thanks alot for the answer. This will for sure help me out in other situations.

However the solution to my problem showed to something as simple as this:

You need an ABSOLUTE reference which is \$A\$1 - which you can do by pressing the F4 key with the cursor on the A1 in the formula bar (or just type the dollars)

For reference

\$A1 would always refer to column A, but variable rows
A\$1 would always refer to row one but variable columns

Thanks again though!

6. ## Re: Find and replace in formulas

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

There are currently 1 users browsing this thread. (0 members and 1 guests)