You mentioned that you are using Excel 2007. I am pretty sure that is your problem. As recently as Office 2016, reading characters inside Excel often misbehaved in the ways you describe. Upgrading to Office 365 or 2021 would almost certainly solve your problem.
