substrings

  1. D

    Extract X-number of words that surround a keyword or keywords in Excel

    Hello - I would like to find a way to (i) extract a certain number of words, that surround a keyword/s (and include the keyword in the extraction, and (ii) have the keyword/s colored in the extraction. I have ~90,000 biographies that I am looking to "classify", based on keywords. With that...
  2. L

    Instr substrings

    Hi all, Is it possible to use multiple substrings with inStr? I want to test if the following characters are contained within mystring /, \, ?, %, *. Many Thanks
  3. S

    Find and remove list of substrings from larger list of strings

    I have three lists: > LIST 1 is a set of substrings that need to be removed from the main list - LIST 2. The substrings are either a prefix or a suffix (either the beginning or end of one of the strings in LIST 2). > LIST 2, as mentioned, is the main list that needs to have one of the...
  4. C

    Using match, index to return substring

    My spreadsheet consists of: column A: single numbers or letters from 1-10 and a-j column B: first-name sp last-name. (Abe Lincoln, George Washington, etc) column f: single numbers or letters column g: return last name only. how can I combine both following formulas to yield the last name only...
  5. G

    HELP: on a string

    Hi all, how do i cut the last part from the url without "T-Shirt-#" for example: url/global/Holidays/Halloween/Frightening-Pumpkin-T-Shirt-1117/ -------------return Frightening-Pumpkin url/Holidays/Christmas/Who-Needs-Santa-Ive-Got-Grandma-T-Shirt-7391/ --- return...
  6. A

    Extract multiple substrings from within a string

    I have a tally sheet with field inputs of nurses working days. I need to separate # of week days and of weekend days. The sheet looks like this : <tbody> Site Name Dates in 2013 MUL MK <tbody> 05,12,19,26 Jan, </tbody> MUL PN <tbody> 21,26,27 Jan, </tbody> MUL RM <tbody> 29...
  7. R

    Formula to extract variable substring from string with multiple spaces

    Hi. I've found several posts about returning variable substrings that dealt with one or two spaces, but I have not been able to find anything that is for multiple spaces. The number of characters before the substring will remain constant. For example: Income from transmission agreement - 83...
  8. M

    INDEX.MATCH w/ Substrings and Dynamic Range

    Hello everyone, Goal: I am trying to find 2 substrings ("sensor", "speed") in separate columns (cat1, cat2) located within ±2 rows from a given row. If the substrings are found, return a value from another column (areacode) and finally write "X" if all of the above is successful. For...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top