Hi robertvarnam1,

Sorry that we don't have such feature. However, with our Find and Replace in Multiple Workbooks feature, you can find-and-replace across multiple workbooks and worksheets. To do so, please follow the steps below:

1. Under Kutools tab, click Find > Find and Replace in Multiple Workbooks.
2. Click the Replace tab, type [*] in the Find what box, and leave the Replace with box empty.
3. Select the workbooks and worksheets with references in formulas to other workbooks you want to remove.
    

4. Click Replace All, you will see all the workbook names in the formulas are removed.

Note that you don't have other values that are enclosed with [ ] that you don't want to remove. If you do, in the Find what box, you will have to add the actual workbook name, for example, [Book1].

For more details of the feature, please see this tutorial: https://www.extendoffice.com/product/kutools-for-excel/excel-find-replace-in-multiple-sheets-files.html#a3

Amanda