Dear Zeunasc, Another Solution...... =SUBSTITUTE(A1,"remark 10/19/2011"," ")
-- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> On Thu, Oct 20, 2011 at 12:43 AM, Zeunasc <timothy.ry...@gmail.com> 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, 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 permit tcp host computer1 > host computer2 eq 80 > > I need to remove the section of text that reads "remark 10/19/2011". > There could be 1000+ lines, so I need to be able to loop the code > until there all of the remarks have been removed. > > Any help is appreciated! > Z > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
