I have a sheet which is a mixture of SharePoint list imports, pasting from a webpage etc. During this process, some zero width spaces are littered throughout the document. Of course it's helpful that I can't see them and don't know there is even an issue until I export to my other programme.
How can I sweep through my entire sheet and REMOVE all zero width spaces? Kill them all? Dead?
I've left the below text with some of those before the L
Logistics Finance & Medical
And here is what it looks like when I put it into a unicode viewer. And this is on one cell. I have 2500 rows and about 20 columns.
Edit: Typo in the title already. Good start that.
How can I sweep through my entire sheet and REMOVE all zero width spaces? Kill them all? Dead?
I've left the below text with some of those before the L
Logistics Finance & Medical
And here is what it looks like when I put it into a unicode viewer. And this is on one cell. I have 2500 rows and about 20 columns.

Edit: Typo in the title already. Good start that.