title: excel vba: make part of string bold
body: <p>I have excel cells which contain entries like this:</p>
  
  <pre><code>name/A/date
  name/B/date
  name/C/date
  </code></pre>
  
  <p>Cell content is displayed on multiple lines in the same cell. I would like to make only "name" bold for all entries. I recorded a macro and I think the solution must be something like this:</p>
  
  <pre><code>ActiveCell.FormulaR1C1 = "name/A/date" &amp; Chr(10) &amp; "name/B/date" &amp; Chr(10) &amp; "name/C/date"
  With ActiveCell.Characters(Start:=25, Length:=4).Font
      .FontStyle = "Bold"
  End With
  </code></pre>
  
  <p>What I don't know is how to get the start value and the length of each entry. Anyone got an idea?</p>