M
M
Maxim Timofeev2015-09-12 12:16:40
Visual Basic
Maxim Timofeev, 2015-09-12 12:16:40

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

1 answer(s)
M
Maxim Timofeev, 2015-09-12
@webinar

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 question

Ask a Question

731 491 924 answers to any question