I sometimes get a unique character in cells that looks like a single quote. It isn't something I've typed, it just shows up. I've tried using find and replace to get rid of it, but get an error message saying excel can't find any matching data to replace.
Does anyone know what this is, how to avoid it and how to get rid of it? I need to get rid of it because any record that has it wont import into Access.
Does anyone know what this is, how to avoid it and how to get rid of it? I need to get rid of it because any record that has it wont import into Access.