'Find and Replace' issue

Hello All - My 'Find and replace' has just stopped working and I can't seem to get it working properly.

I have attached a workbook so that you can see the problem. I typed 'Fish' in a column, the did a find and replace putting in 'Fish Paste' and did a replace all, but the cell is still reading 'Fish', although in the formula bar it's shoeing 'Fish Paste'. Interestingly, if you change the width of the column the word 'Fish' disappears altogether - can anyone help me fix this please, thanks.

Hello AliGW - thanks for your help - your suggestion did partially sort things, but I have attached the file again, this time with a column filled in with 'Light trap' and when I do a 'find and replace all' with the word 'Light' I'm left with blank cells - although playing around with the 'Wrap text@ does seem to again partially fix this, but I've never had to do any of this before!

How do I add the file again please?

Hello AliGW - thanks, attached is the updated worksheet

Hello AliGW - Ok could see that this issue had a potential for a difficult fix, so I decided to close my work without saving it and reopen and at the moment everything seems to have settled down an the 'find and replace' is working well again. I probably activated some function or other without knowing it, which initiated the problem. many thanks for your help - I have added to your reputation.