Re: $$Excel-Macros$$ Removing specific characters from a string of text

For the actual text, rather than SUBSTITUTE, one way is, C7 & copy down. =IF(ISNA("remark "&LOOKUP(2,MATCH("*"&TEXT(ROW(CurrPeriod),"mm/dd/")&"*",A7,0),ROW(CurrPeriod))),"",A7) Haseeb -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Haseeb, Can you help me to modify this slightly? I still need to use the date range as specified in A2 and A4, but instead of doing the whole substitution, I would like for it to either return the actual line to the C column if it contains a remark+date in valid range, or a blank line if it doesn

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Hello Zeunasc; I am not good in to explain something. Here is an attempt. Hope this would help you. A2 = Start Date, here 10/20/2011 A4 = End Date, here 10/25/2011 Basically 10/20/2011 is 40836 (40836 days after 1/1/1900) & 10/25/2011 is 40841 (40841 days after 1/1/1900). If you change the

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Ok, I figured out how to set it to a blank line by changing the first value in the CHOOSE function to "" instead of A7. I would still really like a plain text explanation of the formula for my own education. I think I have a basic understanding of it, but I doubt I could recreate this, or intelli

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Wow, that is really great. I have two further requests... can you walk me through the formula used in column C so I can learn? I haven't ever seen or used a few of those functions (lookup, as opposed to vlookup or hlookup, or Choose). Also, as I don't understand the logic yet, how can I modify t

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Hello Zeunasc; Try the attached. Enter a start date in A2, & End date in A4. HTH Haseeb -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldaily

Re: $$Excel-Macros$$ Removing specific characters from a string of text

As a follow up question, I have to do this review once a quarter, and the remark dates will change. How would I, programmatically, parse out the date string, then use that in an if/then... say, if this line contains a date between 10/01/2011 and 12/31/2011. I know that the values are strings, so

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Both of these solutions work great... should have paid more attention to the built in functions! Thank you both! On Oct 20, 4:23 am, NOORAIN ANSARI wrote: > Dear Zeunasc, > > Another Solution.. > =SUBSTITUTE(A1,"remark 10/19/2011"," ") > > -- > Thanks & regards, > Noorain Ansari >  *http://ex

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Dear Zeunasc, Another Solution.. =SUBSTITUTE(A1,"remark 10/19/2011"," ") -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 20, 2011 at 12:4

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Hi, Try this: =REPLACE(A1, FIND("remark 10/19/2011", A1), LEN("remark 10/19/2011"), "") Regards, Swapnil. On Thu, Oct 20, 2011 at 12:43 AM, Zeunasc wrote: > I know that this is relatively easy, but it has been years since I > have done any Excel VBA. I am parsing out some firewall rules, an

$$Excel-Macros$$ Removing specific characters from a string of text

I know that this is relatively easy, but it has been years since I have done any Excel VBA. I am parsing out some firewall rules, and in order to compare lines, I need to remove a section of text from within a string. The strings will look like this: access-list BldA-I line 5 remark 10/19/2011 p