Find function

[Simmo1313]

I have had to merge two copies of a workbook and to do so requires me to find all references to cells that may have now a different location.

I am using the find function to locate all the cells and trying to use the replace all function to speed things up.

The only issue I am finding is when I search 'Sheet1'!E1 for example, it returns the following results

'Sheet1'!E1
'Sheet1'!E11
'Sheet1'!E13
'Sheet1'!E101
'Sheet1'!E1123

Etc.

I want to find only 'Sheet1'!E1, is there a way to input this so that I dont see the other results??

Thanks

 

[Joe4]

Can you post the full formula in the cell that uses the 'Sheet1'!E1 reference?