Forum Discussion
How to remove invisible character
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_AccountsMar 23, 2022Copper ContributorThanks, 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?- Donald_Genes_Mar 23, 2022Brass ContributorIs this what you want.
I use simple PQ?- Samson_KazikoOct 18, 2022Copper Contributor
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
- Detlef_LewinMar 23, 2022Silver Contributor
- Mannai_AccountsMar 23, 2022Copper ContributorYes this also tried.. nothing happend.
- Donald_Genes_Mar 23, 2022Brass Contributor
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
- Mannai_AccountsMar 23, 2022Copper ContributorCan you please help if I send the excel sheet personally? if yes please share your email.
Thanks..