title: find substring in a string, but look from the right to the left excel
body: <p>I had originally asked the question below and found a good formula 
  <a href="https://stackoverflow.com/questions/51792735/excel-formula-find-part-number-in-file-path-text-string">excel formula find part number in file path text string</a></p>
  
  <p>So after using the <code>=MID(A1,SEARCH("????-??????-??",A1),14)</code> formula to find the part number names things seemed fine until I ran into data that looks like the sample set below. </p>
  
  <pre><code>c:\users\stuff\folder_name\folder_name_9876-vv-123-Ag\1234-000001-01_ baskets_1.pdf
  c:\users\stuff\folder_name_9876-vv-123-Ag\random file_1234-000001-02_ baskets_2.pdf
  c:\users\stuff\folder_name_XXXX-XXXXXX-XX\1234-000001-03_ baskets_3.pdf
  c:\users\stuff\folder_name\1234-000030-01_ tree_30.pdf
  c:\users\stuff\folder_name\random text_1234-000030-02_ tree_30.pdf
  c:\users\stuff\folder_name\more random stuff_1234-000030-02_ tree_30.pdf
  </code></pre>
  
  <p>I am looking thru a few hundred thousand file names and I know I am missing some important files due to the false positive triggers. Like  <code>9876-vv-123-Ag</code> it technically fits the <code>????-??????-??</code> format but is not what I want to extract from the string. Now to the question, is there a way to apply <code>=MID(A1,SEARCH("????-??????-??",A1),14)</code> that can look from the right side of the string and work its way left to ensure that it grabs the last sub-string in the full string that meets the  <code>????-??????-??</code> format?</p>
  
  <p>or is there a way to set the wildcard search to numeric only instead of anything in that <code>????-??????-??</code> format?</p>