Excel cell comparision

ExcelComparision.xlsx
Hello,

I have two columns as below..

PHP Code: 

ColumnA                                                                ColumnB
apple                                                                     apple
banana                                                                   apple
orange banana apple                                                 apple   banana orange
apple banana                                                           banana    apple  orange 


now I want to compare these two cells. The problem here is eventhough vaules are same in both cells, as they are in different order, when i compare it, it says false. I'm using simple command "trim(A2)=trim(b2)". Also there could be extra spaces and special characters in any of those cells. I have attached the workbook with sample data.

I should see following result...

PHP Code: 

ColumnA                                   ColumnB                           ColumnC
apple                                       apple                                TRUE
banana                                    apple                                 FALSE
orange banana apple                  apple   banana orange          TRUE
apple banana                            banana    apple  orange        FALSE 


Is there any command I can use to accomplish this? Please advise. Thanks.

It is pretty close to my actual data except that cells may have extra values, may have extra spaces in any or both cells and may have special charter (*Apple *Orange). Thanks.

That is correct.

Thanks. It may have upto 15 values.