Hi all,
Is there a switch or checkbox somewhere that I can use to exclude formulas from a global replace? I am trying to replace some text in cells of worksheets. However, the text is also utilized in formulas throughout the workbook, and it is necessary that it NOT be changed there. I know I could use “find next” before replacing, but there are hundreds of occurrences of this text throughout the workbook, and this would be very impractical. I’m hoping there’s an easier solution. Thanks.
Bookmarks