substrings

Quite a complicated question for Excel, I think, but okay... There are 10 thousand lines. For each unique string, need to find matching strings using substrings. That is: 1) yellow apple, ..., 9999) golden apple - input values. 1)Yellow apple and 9999)golden apple are output values that need to...

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

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

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

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

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

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

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

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