below formula cleans all nonprinting characters and other 'junk' data from a cell.
I have learned that CHAR(127) is also a character that should be integrated in the formula.
I do not know how to nest the 'subformula' = SUBSTITUTE(B127,CHAR(127),""), into the above code
Help is much appreciated. Thank you very much in advance.