Use the CLEAN () function to remove non-printable characters in Excel The CLEAN () function in Excel removes all non-printable characters from a given text string.

You can use this same formula to remove other characters from a string of values in Excel. You can also use the Right function, where you tell Excel to delete the numbers on the left and keep the ...

Not all sort tasks in Microsoft Excel begin with the characters to the left, but getting around that issue is easier than you think. Susan Harkins shows you how.