text– The text whose non-printable characters are to be removed.
- This function only removes non-printable ASCII characters. Non-printable Unicode characters that aren’t found in ASCII will not be removed.
- Google Sheets does not show non-printable characters in the UI, so using this function will not typically result in any visible changes.
CHAR: Converts a number into a character according to the current Unicode table.
TRIM: Removes leading, trailing and repeated spaces in text.
SUBSTITUTE: Replaces existing text with new text in a string.