Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

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.

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.