I have a excel workbook, in which certain cells are referenced with the User
defined function names.

say cell B2 has a reference to user defined function
='C:\ExcelAddin\XLStart\ABC.xla'!getValue(B1,"OWNE R")
and B3 has a reference to user defined function
='D:\ExcelAddin\XLStart\XYZ.xla'!getValue(B1,"SALE ")

I want to replace all these cell references in the complete sheet containing
getValue(....) with only the function name.

Like reference to B2 and B3 should be like
B2 = getValue(B1,"OWNER")
B3 = getValue(B1,"SALE")

Please help.

Thanks,
Sandeep