How to copy/paste text in a cell, but not being able to save the worksheet with that text

Good afternoon,

I have an Excel workbook that has multiple worksheets and I would like to to be able to copy/paste text into one of the worksheets, but when the file is saved, it automatically deletes that text. The other worksheets need not be affected by this. And making the file read only obviously would not work in this case. I also know the worksheet can be protected, but I'm not sure how to make it so the text is automatically deleted.

Any help will be appreciated.