title: find the first instance of a specif character and get the left value using vba
body: <p>How to find the first instance of a specif character and get the left value using vba</p>
  
  <p>a= "\abc\123\abc\test\test123\123\1248\1234\Dec 03"</p>
  
  <p>I need the output as "\abc\123\abc\test\test123\123\1248\1234", that is it should detect the first \ and get remaining string from the left using VBA.</p>
  
  <p>Thank you.</p>