title: How would I apply the Mid function to this string in Excel?
body: <p>I am trying to use the Mid function in Excel, but I am stuck.</p>
  
  <p>In column A, there is a string that looks like this: _string_unwanted</p>
  
  <p>where _ equals a space, "string" is a string of variable length that i want to extract, _ is the 2nd space, and "unwanted" is a string of variable length that i don't care about.</p>
  
  <p>Here's my function:
  = Mid(A1, 2, <strong>__</strong>)</p>
  
  <p>I put "2" to start at the 2nd character spot since I want to ignore the 1st space.  What do I put in <strong>_</strong> such that it finds the string of variable length? Meaning, it just isolates the "string" part of the above string..and ignores the 2 spaces, and the "unwanted" string?</p>