How to Remove Text in Excel

With Text Toolkit for Microsoft Excel

With the Text Toolkit for Excel, you can easily remove characters and strings from the selected cells. In this manual, find out how to use the Remove Text utility.

  1. To run Text Toolkit in Excel, go to the Home tab and click the Text Toolkit icon:
    This is the Text Toolkit icon.
  2. Select Remove Text:

    Select Remove Text.

  3. You will see the Remove Text pane. Select your options and click the Remove button:

    The Remove Text pane.

  1. Select the range of cells where you want to remove text.
  2. Select this radio button to remove specific characters or text strings. To remove several characters or strings, enter them and press the Enter button after each. If you want to remove spaces, press the Space key and then Enter. To delete line breaks, press Shift+Enter and then Enter.
  3. Tick the Case-sensitive box if you want the tool to distinguish the case of text you entered from text in your cells. For instance, with selected Case-sensitive, "E" and "e" will be recognized as different values, though with unchecked Case-sensitive, they will be identified as the same values and removed.
  4. Also, you can get specific character sets removed. Check this radio button, open the drop-down list, and select the set you want to eliminate:
    Decide which character set to remove.
  5. If there is a check mark next to Don't change cells with formulas, the add-in won't process cells that contain formulas.
  6. With the Create a backup copy option selected, the Restore button is added and a hidden copy of your sheet will be saved. After the tool has processed your data, the Restore button gets enabled. You can click it and return to the previous version of the processed sheet if necessary.
    Here's the Restore button.

    Tip. To see available backup copies, right-click any sheet tab in your Excel workbook and choose "Unhide".

    Unhide any of the backup sheets that you can see in the list.

    Note. You can delete hidden backups with the Remove all backup sheets option in the More menu. To see it, click the three dots in the lower-right corner of the Text Toolkit pane:

    Find the Remove all backup sheets option in the More menu.

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.