Remove characters

Modified on Wed, 19 Oct, 2022 at 6:42 PM

Cleaning data in Excel often involves a number of actions that, if performed manually, could easily take hours. The Power-user add-in includes a feature to remove custom characters, helping you easily clean your data.

To remove characters from an Excel range:

  • Select the range to clean
  • From the Power-user tab in Excel, click Remove characters
  • The below dialog box opens. Select the appropriate option:
    • Extra spaces: this will clean leading and trailing spaces, while also remove multiple spaces within your text. This can also be achieved using a TRIM() function.
    • Line breaks and non-printing characters: this will remove line breaks and non-printing characters from the selected range. This can also be achieved using a CLEAN() function.
    • Custom characters: specify custom characters that you would like to remove in the selected range. You can make this case sensitive or not using the checkbox just below.
  • Click OK to validate.

Power-user add-in l Remove extra spaces, line breaks, non-printing characters and custom characters from a range in Excel

See also: Add characters

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article