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.

The standard technique for creating an "ñ" or "Ñ" on a keyboard involves using your numerical keypad to insert the corresponding ASCII code. This technique becomes more difficult, or even impo ...