Searching for a string in all the formula cells in a workbook

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I want to do a search on a string in all the formuals in my workbook.
Say the string is "ABC_DEF". However there is also a "New ABC_DEF
scattered across the formulas as well. How do I do a search o
"ABC_DEF", without getting results that include "New ABC_DEF"?

Thank-you
 
i hope its as simple as selecting the box
"match entire cell contents"

so hit ctrl-f for find, then check the box

excel 200
 
If you can't pick out something that makes the string unique, then maybe you
could do a small workaround.

Select your range
Edit|replace
replace: new ABC_DEF
with: $$$$$$$$$$$ (any unique string)

Then do your find (or replace???).

Then reverse that first replace:
Select your range
Edit|replace
replace: $$$$$$$$$$$ (that unique string)
with: new ABC_DEF

This may not quite fit, but you may find it very useful for any finds/replaces.

Try Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/
 
Back
Top