Hidden characters in Excel

Hello,

I Just found out that multiple Excel lines in my files contains hidden characters that are not displayed in Excel.

When I copy-paste this content into Word, it is displayed as 2 square outlines. Each square outline has one more square outline inside.

Would you please let me know how to identify the origin of this issue?

All the best.Character.png

Check what this return

Formula:

Please Login or Register  to view this content.

It returned 69. Did I apply the formula correctly?

Just copy formula but replace cell where is your problematic data (in example B12, change with desired cell).

Char 69 is just "E" so I doubt it cause some errors.

Originally Posted by zbor

Just copy formula but replace cell where is your problematic data (in example B12, change with desired cell).

Char 69 is just "E" so I doubt it cause some errors.

Thank you! The result is 65. Any clues?

Nope.
can you upload example workbook with your problem?

Delete all unneeded or private informations and eplain where are problematic rows.

Hello, You can find the issue below, after Octavius. (use the directional keys to navigate and the cursor will get "stuck"). This was copied directly from Excel.

Octavius​​, mais

Also, if you copy-paste this string in Excel, you'll get the unwanted hidden code.

Well, after reading about the code function, I found out that the result for me is 63 = ? Did you get this results as well?

Is it possible to include this code unintentionally while typing text into excel?

The code number is 63 = ?

Originally Posted by Speshul

Get the code number and translate it:

=CHAR(CODE(LEFT(B12,1)))