I feel like a real dumbo asking this, but I'm in a little pickle here. Say I want to replace A2 only to a named cell call CellTwo. If I use find/replace A2, it will replace A20, or BA20 as well.
A2 appears in different scenarios and there are too many that I cannot recall or can't really locate all the scenarios in which it exists to redefine the search criteria, for instance A2 will appear like this "(A2:...", "...:A2", "...*A2", ".../A2", "A2=...", etc, etc. There may be many scenarios and I, as I said, if I say FIND ALL, it will give thousands of entries with formulas that really really long (so long that you can't even see the end of the formula on the Search Results).
Is there a way to just replace A2 and nothing else that has "A2" in it? I use XL2007 and I've tried "Match Entire Cell Contents" and it gives me no results when there definitely cases of where A2 is used alone.
Ideas?
Ron
EDIT: I want to replace all instances on the entire workbook by the way, not just the current worksheet. Thanks
A2 appears in different scenarios and there are too many that I cannot recall or can't really locate all the scenarios in which it exists to redefine the search criteria, for instance A2 will appear like this "(A2:...", "...:A2", "...*A2", ".../A2", "A2=...", etc, etc. There may be many scenarios and I, as I said, if I say FIND ALL, it will give thousands of entries with formulas that really really long (so long that you can't even see the end of the formula on the Search Results).
Is there a way to just replace A2 and nothing else that has "A2" in it? I use XL2007 and I've tried "Match Entire Cell Contents" and it gives me no results when there definitely cases of where A2 is used alone.
Ideas?
Ron
EDIT: I want to replace all instances on the entire workbook by the way, not just the current worksheet. Thanks
Last edited:
