Removing part of a formula which is identical in same formula in 100s of cells

I have 100s of formulas located in 100s of cells in the same active worksheet which contained a link to a workbook that is no longer relevant. By way of example, the referenced link is:

C:\Users\GARRY\Documents\BUSINESS\TEMPLATES\Microsoft Office\Excel\Savings & Retirement\[PERSONAL INCOME EXPENSE CASH FLOW01_2012.xlsx]

in an sample formula as follows:

='C:\Users\GARRY\Documents\BUSINESS\TEMPLATES\Microsoft Office\Excel\Savings & Retirement\[PERSONAL INCOME EXPENSE CASH FLOW01_2012.xlsx]INPUT Detail-Expense'!$L$765

Is it possible to create a macro that contains the appropriate code to automatically amend that portion of all the formulas contained in all the cells to remove this link.

Thanks in advance for your help

RoyUK

Thanks very much. IT WORKS!!