• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

to find and replace in a formula

G

GN0001

Member
I have a spreadsheet and each cell has a formula that has cell G5 and H5, I want to replace G5 and H5 with G8 and H8 all throughout the worksheet. What is the solution? I used find and replace, it didn't find the value.


Thank you for the help.

Guity
 
Hi, Guity,

Have you ensured that

1. "Match entire cell contents" is not checked in the find/replace dialog box?

2. The "Look in" option is enabled with "Formula" and not with "Values" or "Comments"?
 
I unchecked Match entire cell, but it didn't work. I tried to find Look in option to enable it, but I couldn't find this option (because I searched and I found the the Look in should be enabled with formula), but the point is that I couldn't find Look in Option.... any help?

Guity
 
Guity,


When you press CTRL+F to get the Find dialog box, click on the "Options >>" button to view more options that are available.


Now you should be able to the see the Look In drop down.


HTH

~Vijay Sharma
 
You must log in or register to reply here.
Back
Top