Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have the following formula in a column of 1000+ rows: =IF($E$13=1,0,IF(Census!$L$8=99,0,Census!$H$8)) I want to use Find/Replace to find all the references to "$E$" and change it to just be "E". I keep getting the message that "We couldn't find what you were looking for. Try changing the search Options to "Look in:Values", but Values is not an option. How can I make this change without doing it manually 1000+ times.
Solved by V. Q. in 5 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/06/2018 - 07:16
Hi there!
Excelchat Expert 18/06/2018 - 07:16
There should be an option when you go into the Find and Replace menu - "Look in - Formulas".
Excelchat Expert 18/06/2018 - 07:16
Can you see that option in there? If so, might you be able to try it and see it the find/replace works?
User 18/06/2018 - 07:17
The only option I have in "Look in" is Formulas.
Excelchat Expert 18/06/2018 - 07:18
That's the one. But select the entire column that the formula is in, and then find/replace, look in formulas, $E$ to just E
Excelchat Expert 18/06/2018 - 07:20
I could also process it as well if it's not working for you if you can attach your file?
User 18/06/2018 - 07:20
Oh man! That was too easy. I had only selected a portion of the column I wanted to change. When I selected the whole column it worked like a charm! Thank you!
Excelchat Expert 18/06/2018 - 07:20
Ahhh yes that would do it!
Excelchat Expert 18/06/2018 - 07:20
I'm so glad to help.
Excelchat Expert 18/06/2018 - 07:21
Have a great day and please feel free to open a new session if you need further assistance and we will be happy to help!
Excelchat Expert 18/06/2018 - 07:21
All the best ~
User 18/06/2018 - 07:21
Thanks so much!
Excelchat Expert 18/06/2018 - 07:21
My pleasure!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc