Forum Discussion

Copper Contributor

Mar 23, 2022

How to remove invisible character

Please help to remove invisible character from Cell "B3". No additional space or any symbol is showing in cell "B3". But when we apply LEN function, it is giving 2 characters as below. ...

excel

Donald_Genes_

Brass Contributor

Mar 23, 2022

Try
=Value (Len(B3)) or NumberValue(Len(B3))

Or =--TRIM(CLEAN(SUBSTITUTE(B2,CHAR(10),"")))

Or
= Value(Substitute(B2," ",""))

char160 is a hard-space (a non-breaking space). It's different from the regular space (char32), but -- to the naked eye -- they look identical (and invisible). 🙂

Mannai_Accounts

Copper Contributor

Mar 23, 2022

Thanks, but It is not working...
This is not like Char160. this case we cannot see the character by way of space or any other.
Code is showing as 63 but it is not a character like "?" or "Ω"
Any other options?