I have found an issue with Excel the issue exists in 2016 and 2019. If you have a series of columns with spaces in them and want to use find replace to remove them after the first time Excel will no longer find anything that you search for in other columns. This happens when you change what your are using for the find replace options.
So I have a spreadsheet with 2 identical columns, they contain spaces, I use find replace on column A for the space I use ALT-0010 using any other option yields the same results.
I tell Excel to find all spaces and replace them with 34 it finds 64 and replaces them with 64, I go to Column B and bring find/replace back up delete the items in the find replace fields. I enter the same information and it says nothing found.
I recorded a video as it is much easier to see it than type it out?
