FilterValues ( Substitute ( Info ; " " ; ¶) ; Substitute ( Stocks ; " " ; ¶ ) )
May work part of the time, but punctuation in Info immediately after a stock name will defeat it. You could use brackets to substitute returns for them as well as the space character in the first substitute, but then a period in the example of your stock name will be a problem ( AAA.E ).
Hello PhilModJunk ,
Thank you for the respond.
as you said , it did not work
But may provide the basis for a method that does. It can certainly be modified to work with punctuation, but you'd need to modify your data in stocks to not use punctuation characters.
The alternative is to set up a looping script and or recursive custom function for this.