How to Remove by Position in Excel

With Text Toolkit for Microsoft Excel

With the Text Toolkit add-in for Excel, you can easily remove characters by position from the selected cells. In this manual, find out how to use the Remove by Position utility.

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

    Select Remove by Position.

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

    The Remove by Position pane.

  1. Select the range of cells where you want to remove text.
  2. Choose this radio button to remove a definite number of the first characters from the selected cells. Enter the number of characters to remove into the input field.
  3. Check this radio button to remove a definite number of the last characters from the selected cells. Enter the number of characters to remove.
  4. Select All before text to remove all symbols before certain characters. Enter these characters into the input field.
  5. Tick All after text to remove all symbols after certain symbols. Enter these symbols.
  6. If you selected All before text or All after text, you can tick the Case-sensitive box to make the tool 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.
  7. If you tick the Enable Undo box, the Undo button will appear:
    Tick Enable Undo to be able to Undo.
    As soon as you hit Remove, the Undo button will become clickable and you'll be able to undo the changes made by the add-in:
    Undo the changes.

Ask a question (posted publicly)

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.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.