Using 'Filter(array,"text")' within a macro for lines that begin with "text"

[Rhudi]

I have a section of code that looks likes this:

Please Login or Register  to view this content.

It reads a cell that contains multiple lines of text (the 'interface' section for one group of sub interfaces in data from a Cisco 'sh run' command).
These will be multiple lines, where there will be one or more lines that start with the text "interface ". Unfortunately, the way I'm doing this will find the word 'interface ' anywhere on the line, not just the lines that begin with that string.
You can see in the above bit of code, I cheated by adding a few characters.
How do I do an array filter for a "begins with" match?
My little "For x" / "next x" loop is a kludge to add "no " to the beginning of the interface lines that I found. I couldn't figure out (well... find on google) how to just add the string to the beginning of all hits in my new array.

I used to have code that looked like this:

Please Login or Register  to view this content.

that has abruptly stopped working correctly (Post migration to a Windows 7 system and unknown updates to Office). That code would do the "begins with" quite nicely and for multiple contiguous columns.
Now, I have to loop through and do this "manually"

[Rhudi]

Here is my drain-bamaged "solution"...

Please Login or Register  to view this content.

*sigh*

[Marc L]

Filter function example "begins with" :

Please Login or Register  to view this content.

[romperstomper]

I think you'd be better off just filtering for interface and then testing the left part of the string in the loop before you prepend 'no '. It would seem more efficient than two loops.