LinkBack URL
About LinkBacks
I am having an issue with the find and replace function. I am only able to search formulas, and nothing else. Does anyone have any suggestions?
find and replace function is not working correctly
I am having an issue with the find and replace function. I am only able to search formulas, and nothing else. Does anyone have any suggestions?
in the Find and Replace window, click on the Options button and select Values from "Look in" field dropdown.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
I'm actually having the same problem in Excel 2010 Professional. Quite out of the blue, the pulldown menu (Options->Look in:) is only showing Formulas as an option. For me, it's only in the Replace tab. Find is fine. I even tried stripping out the Formulas to just get the values, and I quit and restarted, but it's still missing the Values option.
find-replace.gif
Last edited by Isara; 10-10-2012 at 04:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks