How to compare 2 cells with text and extract diferences to a 3rd one

[AVWork]

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

[cobbe]

Is that ok for you?

[AVWork]

Thanks, cobbe, but I'm afraid it did not work for me.

Just to clarify something: in cell A1 I have "apple (1); orange (2); pear (3)" and in cell B1 "apple (1); pear (3)".

Thanks anyway!