I’ve mentioned in the past that I am unable to convert the non-display character alt+010 (or any alt code) on my Mac, because it doesn’t do that sort of thing. I have some data that contains alt+010 characters, and I either have to change them on my work PC, or, if working from home, have a coworker do it for me. As it happens, my roomie has a shiny new PC laptop so I asked if I could edit the file on her computer.
The file opened in Excel 2010. (I have 2003 on my work PC and on my Mac.) I was able to do a Find on alt+010, but… the Replace tab was greyed out. So was the Find all button. I thought maybe Excel 2010 might have a ‘feature’ where you can’t replace something (or everything) until you’ve found it once. Nope. I tried alt+010 and a word I could see in the data. So that didn’t work.
How to you do a Find all and Replace in Excel 2010?