Mar 23 2022 12:31 AM
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.
Mar 23 2022 12:39 AM - edited Mar 23 2022 12:41 AM
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). :)
Mar 23 2022 01:09 AM
Mar 23 2022 01:13 AM - edited Mar 23 2022 01:15 AM
Strange
Take the data to Power Query and let power Query automatically detect
Make sure you Trim the column
Or use Add Custom Column
Text.Select([Column A], {"0".."9"})
Also copy the entire range of data and paste on another sheet using AlT H VV
Let's see what's wrong with the excel worksheet
Mar 23 2022 01:45 AM
Mar 23 2022 03:07 AM
Mar 23 2022 04:32 AM
Mar 23 2022 05:07 AM
Mar 23 2022 07:45 AM
Oct 18 2022 05:12 AM
@Donald_Genes_ may you please assist with how to remove invisible characters on a file. You m,ay assist with using power query for the same if possible but at the end of the day i am trying to find a way to remove invisble characters. I am not sure how i can attach a file here.
Thank you very much
Oct 18 2022 06:15 AM