I am new to excel, but Im no novice, I have spent years working in Google sheets.

I have a sort of hate for ms office products, I find them challenging to use and not really intuitive. So please forgive me if I am overly critical!!

I am working though some tutorials to build my portfolio, and I was learning how to add a ' into a cell as a dirty way to format the cell as text when inserting a number. So '0044 formats as text. This isn't really great, but it works for some situations.

Now I want to remove the ' from my cells, so I do what anyone would do I go to find and replace to search for ' and replace with null.

Find gives me the alert saying "We couldn't find what you were looking for."

Im really not sure what is going on... Please help!

4253.JPG