Being driven made by Zero Width Space throughout sheet.

[Darkstar_]

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.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Being driven made by Zero Width Space throughout sheet.
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Darkstar_]

I cross-posted?

 

[Fluff]

Yes.

 

[Darkstar_]

You mean in the completely different site forum? On a different domain?
Where they asked me to provide an example sheet, which was completely not required?

 

[Fluff]

That's right. Did you follow the link in the rules to understand what cross-posting is?

 

[Darkstar_]

Ah ok, well good to know we are getting to the heart of my issue here.