V
V
Vadim Timoshenko2020-06-01 15:55:09
excel
Vadim Timoshenko, 2020-06-01 15:55:09

How to remove non-printable characters?

There is a table with product descriptions.
When uploading a table to an online store, question marks ???? appear in the text.

I cleaned the table before unloading it using the "pechsymv" function.
Excel does not display non-printable characters, but word does. I copied it there and saw this:

5ed4faa1bee78375242057.png

How to get rid of it en masse?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey, 2020-06-02
@DramokL

Good afternoon.
Try to copy this character (i.e. empty space) in Excel and replace it with [ctrl] + [H] with a space.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question