title: Sort column of similar text alphabetically by part of text, not first different letter. Sort column based on another with Excel
body: <p>Here is an example of what I am attempting to sort from A to Z:</p>
  
  <pre><code>&lt;item component="ComponentInfo{com.uniqueActivity}" drawable="charlie"/&gt;
  &lt;item component="ComponentInfo{com.otherActivity}" drawable="alpha"/&gt;
  &lt;item component="ComponentInfo{com.differentActivity}" drawable="beta"/&gt;
  </code></pre>
  
  <p>I want to keep the same structure of each line, but sort the lines A to Z as "alpha", "beta", "charlie" (not by "differentActivity", "otherActivity", "uniqueActivity").</p>
  
  <p>I have tried going about this by extracting the text into another column using the formula:</p>
  
  <pre><code>=RIGHT(A1,LEN(A1)-FIND("drawable=",A1))
  </code></pre>
  
  <p>But this route does not keep "uniqueActivity" partnered with "charlie" when the sorted column is pasted back. There must be an easier way of accomplishing this with only the sort function. </p>
  
  <p>Perhaps we can choose which part of the text to sort by if it comes after "drawable="?</p>