Find and delete data

[sandubandu]

I have following data:

column A contains alphabets i.e a|,b|,c| till k|
Coumn B contains alphabets combinations i.e a|b|c|d|z|, c|d|q|a|, r|a|t|

I want to delet those alphabets from combinations which are not present in column A


for example in combination a|b|c|d|z| should be deleted in new combination should be look like a|b|c|d|

Sample data file is attached.

[Kaper]

To achieve such result with formulas could be not_so_easy. Especially in a situation, when your a, b, c are in real life rather words/sentences than just letters.
So I'd suggest short macro:

Please Login or Register  to view this content.

[sandubandu]

I don't know how to use this code. could you please send me the file containing this code ? please !

[Kaper]

I used here two internal worksheet functions: iserror and match in application context (rather than worksheetfunction or application.worksheetfunction) to skip issues with

Please Login or Register  to view this content.

... and checking errors

PS. file is attached to above post

[sandubandu]

I am not able to download this file !

[Kaper]

Please try again.
Just in case I'm also attaching it again here

[sandubandu]

Hey Kaper, Its working ! thanks a lot :D