title: How to compare if two cells have same characters in any order in excel?
body: <p>I want to compare if two cells in Excel contain the same characters, which could be in any order, using Excel based formulae.</p>
  
  <p>For example, if: </p>
  
  <pre><code>A1= Japan;US 
  
  A2= US;Japan
  </code></pre>
  
  <p>--EDIT--</p>
  
  <p>Another example,</p>
  
  <pre><code>    C1= abcefg
  
      C2= efgabc
  </code></pre>
  
  <p>In both these cases, when I check whether A1=A2 or C1=C2, it should give me TRUE since all the characters in both the cells are exactly the same, albeit in different order. </p>
  
  <p>Ps - These cells could have any character length.</p>