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

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_Accounts

Copper Contributor

Mar 23, 2022

Can you please help if I send the excel sheet personally? if yes please share your email.
Thanks..

Donald_Genes_
Brass Contributor
Mar 23, 2022
Send the file to me I will will use Power query or VBA to clean it

Email address removed