ExcelBanter - Cut/Copy and Paste Functions without old links

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cut/Copy and Paste Functions without old links (https://www.excelbanter.com/excel-worksheet-functions/65360-cut-copy-paste-functions-without-old-links.html)

Cut/Copy and Paste Functions without old links

I have a function on current sheet which refers to cells on other sheet
PSUML5'!F15 ie. Cell F15 on Sheet PSUML5

When I cut or copy this current sheet to another sheet, it still refers to
the original sheet
='[Build Summary - trial.XLS]PSUML5'!F15

What do I do if I just want the function to appear as :
= PSUML5F15
on the new sheet ?

All times are GMT +1. The time now is 12:34 PM.