title: Splitting String With LastIndexOf() in VBA
body: <p>How to split A string By <code>LastIndexOf()</code> in VBA</p>
  
  <p>I have a string which can have these kind of values</p>
  
  <pre><code>Dim input As String
     input =  "customName_D3"
     input =  "Custom_Name_D3"
     input =  "my_Custom_Name_D3"
  </code></pre>
  
  <p>like it can have many <code>"_"</code> in it but after last<code>"_"</code> it contains cell name
  I want to split this string to get cell name and other remaning part as two different strings
  something like </p>
  
  <pre><code>cellName = D3
  remainingString = my_custom_Name
  </code></pre>