Hello,

I have 2 columns with text in cells. Each cell has a concatenation of names, separated by ";". What I have looks like this (simplified example):

Column A

apple (1); orange (2); pear (3)


Column B

apple (1); pear (3)


I need to extract to column C the names in column A that are not in column B. So I should get to "orange (2)" in Column C.

Can anyone give me a hint on how to solve this, please?

Thanks in advance,
AV