Use the SUBSTITUTE () function to remove non-printable characters in Excel Excel offers a CODE () function which returns the ASCII code for a given character.