substring

Hi, I was hoping that someone might be able to point me in the right direction with regards to a vba problem that I have. Basically, is it possible to search for a particular text substring within a string e.g. Searching for substring "is my" within String = "this is my string" I...

Hi I need to develop a macro that extracts substrings from a string like: IF ‘lookup 1’ < 2008 AND ‘lookup 2’ <> 0 Then ‘lookup 3’ = 0 I am looking for values between quotes ‘ ’. The expected output will be sub strings: lookup 1 lookup 2 lookup 3 Thanks

I need to create a macro that will delete all sheets in a workbook that do NOT contain the substrings "Dec" and "09". All other sheets in the workbook may contain some variation of the months of the year (e.g. October 09, Sept 09, Jan. 09, etc) Some workbooks will contain 2 or 3 sheets with...

A few days back in helping a member of newsgroup I have to find number of occurrence of a particular sub string in a string which is entered in a cell. I tried Google search as well as Mr. excel forum search I was not able to get a satisfactory reference. So I created a function to solve this...

Hi, I need to extract substring from a cell.For example if i have a value show below in one cell: Sub=Message from HeepLine & body=Msg ID: 4523_2 pls check job seek.c failed This email message is confidential I need to extract the Msg Id and body of the msg(here, pls check job seek.c failed)...

Hi I am a bit new to excel functions, so want some help. I am writing down one of of the cell's value ( e.g; position D3) in my excel sheet. I have written the value like you can understand my problem. The following code is present in work log column of the report extracted through...

Hi - I'm trying to use a CSE function to sum a given range based on criteria applied to a separate range of the same dimensions (i.e. the {=SUM(IF(...))} convention). The challenge is that the criteria to apply is a list of user-defined substrings present in the range to which the criteria...