Replacing everything within [ ] with something else

[polska2180]

Hi I have formulas referencing different spreadsheets....

[9U_Observations Tracker1.xlsx]Selection'!CX3

,... in sharepoint that seems to be broken through out the entire form so I want to replace everything within [ ] with a new file linked. I can not simply replace the 9U to 9I for example because not all the data points within my range shows 9U, which is part of the problem.

THANKS.

 

[t0azt]

Use find and replace with the find section
[*] and replace with the new file.