title: Excel VBA - using left function with find
body: <p>I'm trying to use the worksheet function "left" in conjunction with "find" to determine a string variable in VBA. However, excel interprets the find function as a VBA function, which yields an error message when resolving.</p>
  
  <p>Below my code:</p>
  
  <pre><code>...
  Else
      MSa = MSa &amp; Left(Range("D22"), Find(".", Range("D22")) - 1) &amp; " " &amp; Range("D25").Value &amp; "."
      Range("Q7").Value = MSa
  End If
  ...
  </code></pre>
  
  <p>where MSa is a string. Can you please advise as to how I can best solve this problem?</p>
  
  <p>Many thanks in advance.</p>