With Ultimate Suite for Excel

Extract substrings in Excel

Whenever you need to take some values out of your column and put them into another one, the Extract Substrings feature from Substring Tools is a real help. And no worries about your original column—it will not change one iota.

Before you start

The things to be remembered:

  • Only one column is processed at a time.
  • Put each of the substrings to be extracted into an individual cell within one and the same column.
  • The result is placed in a neighboring column and your source data doesn't undergo any changes.

How to extract substrings

Click the Substring Tools icon on the Ablebits Data tab and select Extract Substrings to run the tool:
Start the Extract Substrings tool.
Fill in the required fields and pick the options of interest:
Adjust the Extract Substrings settings.

  1. Select a column containing the data to be processed—the Source column.
  2. Using the icons on the right side of the Source column box, you can select your current table column or any other column you need.
  3. Select a column containing the substrings to be extracted—the Substrings range.
  4. If you want to have extracted substrings separated by a delimiter, enter one into the Split with box.
  5. If the search for substrings should be case-sensitive, pick the Case-sensitive option.

For example:
See an example.
Click the Extract button to get your data processed. You will see the result on the right of your source column:
The substrings are extracted.

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.