Answer the question
In order to leave comments, you need to log in
How to remove invisible characters in excel?
there is a column in it for country names. Everything looks ok, but if you copy the cell to the clipboard and paste it, for example, into the search box, then I see "Australia" . There are quotes and a space that are not displayed.
How to get rid of them? I rummaged through the search, but did not find working examples.
Answer the question
In order to leave comments, you need to log in
Understood. The mystique of microsoft. Removing non-printing characters () did not help. But after resaving the file to xlsb it worked.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question