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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top