How to Extract Text in Excel

With Text Toolkit for Microsoft Excel

With the Text Toolkit add-in for Excel, you can easily extract text from the selected cells in your worksheet. In this manual, find out how to use the Extract Text utility.

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

    Select Extract Text.

  3. You will see the Extract Text pane. Select your options and click the Insert Results button:

    The Extract Text pane.

  1. Select columns from which you want to extract text or numbers.
    Note. Columns with extracted substrings will be inserted to the right of each of the initially selected columns in the range. For example, if you extract characters or substrings from column A, the result will be placed to a new column B.
  2. You can extract some number of the first or last characters in a cell. For this, check one of these radio buttons and enter the number of characters you want to get extracted.
  3. Check this option button if you want to extract values by their position in a cell. Indicate the position number of the first character and the number of chars to extract.
  4. To copy and paste substrings before or after some text, choose the corresponding option and enter the text before or after which you want to extract values. Pay attention that the Case-sensitive checkbox has become active.
  5. Tick this radio button to extract all numbers from the selected cells.
  6. The Case-sensitive option is available if you pick the All before text or All after text radio button. If you select Case-sensitive, the tool will distinguish the case of text you entered from text in your cells.

    For instance, with selected Case-sensitive, "TExt" and "text" will be recognized as different values, though with unchecked Case-sensitive, they will be identified as the same values.

  7. Tick this box if you want the result to be pasted as a formula.
  8. 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 Insert Results, 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.