Hello team,
I have a cell that I am sure it has non-printable or invisible characters. some times the end user enters some spaces inadvertently, that causes filter, some of functions and sort don't work. How can I find out what the number of those characters is in ANSI? Is it 160 or 27 or 143? So I can go ahead and remove them with substitute and clean and trim function?
Your help is greatly appreciate.
GGGGG
I have a cell that I am sure it has non-printable or invisible characters. some times the end user enters some spaces inadvertently, that causes filter, some of functions and sort don't work. How can I find out what the number of those characters is in ANSI? Is it 160 or 27 or 143? So I can go ahead and remove them with substitute and clean and trim function?
Your help is greatly appreciate.
GGGGG