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.