title: How to compare only a part of strings in different excel sheets(columns)
body: <p>How to compare two sheet columns specied below, however only part of string in location(column)in sheet1 will matches only part of string with the Location(column) in sheet2?<br>
  1.only 1st two characters of location(column) in sheet1 and 1st two characters of location(column) in sheet2 should match.<br>
   2.only any two characters of location(column) in sheet1 and any two characters of location(column) in sheet2 should match. Please help</p>
  
  <pre><code>Location(sheet1)    Location(sheet2)     
  ____________________________________________
  india- north        USxcs  
  India-west          Indiaasd  
  India- east         Indiaavvds  
  India- south        Africassdcasv  
  US- north           Africavasvdsa  
  us-west             UKsacvavsdv  
  uk- east            Indiacascsa  
  uk- south           UScssca  
  Africa-middle       Indiacsasca  
  Africa-south        Africaccc  
  Africa-east         UKcac  
  </code></pre>