Using the len and clean function, visible length of 10, but using the function after different length
Paste the TXT, also can't see the hidden characters
Ladies and gentlemen, what reason is this? How to quickly find the hidden characters?

CodePudding user response:

Why can't upload attachments

CodePudding user response:

Not at the beginning of the most commonly is in the end,=code (left (b2, 1)) or=code (right (b2), 1) see a try?

CodePudding user response:

refer to the second floor zara's reply:

is not at the beginning of the most commonly is in the end,=code (left (b2, 1)) or=code (right (b2), 1) see a try?

Thank you for your reply, the execution down is 63, I checked 63 representative question mark, but why not visible? If you want to get rid of how to operate?

CodePudding user response:

Question mark, one is real question mark, there is no corresponding in the current character set is a character, you didn't show here, should be the latter,
This, use what formula to generate what? Should be in the formula is not satisfactory, if it's still formula, will start from the formula; If already removing formula, some trouble, save for the XLSX format, use compression software to open, find the cell in the worksheet file, and see what the hex mode, or to find a way to look at coming on?

CodePudding user response:

S the root cause (presumably)
You have a data source, can't identify characters,

S solution (recommended)
Start with your data source view

CodePudding user response:

On view special characters,
Open a command prompt, CMD
CHCP 65001
Switch to a utf-8
Then copy, can try to see the special characters