title: VBA String Characters Excel
body: <p>I am a complete VBA beginner so please dumb your answer down as much as possible.</p>
  
  <p>I need to bold str2. I have worked out how to do it based on a set number of characters however, I have an issue because str02 is dynamic. It is a customers name and therefore, the length changes meaning I can't count characters because I don't know how many there will be. </p>
  
  <p>i.e </p>
  
  <p>Dear Mr Customer (length changes),</p>
  
  <p><strong>bold</strong> Your request has been approved <strong>bold</strong></p>
  
  <p>Thank you</p>
  
  <pre><code>Public Sub ExampleConcatenate()
  
      Dim str1 As String
      Dim str01 As String
      Dim str02 As String
      Dim str03 As String
      Dim str2 As String
      Dim str3 As String
  
      str1 = Range("A14").Value
      str01 = " "
      str02 = Worksheets("Restructure Calculator").Range("D5").Value
      str03 = vbNewLine
      str2 = Range("A15").Value
      str3 = Range("A16").Value
  
      Range("A1").Value = str1 &amp; str01 &amp; str02 &amp; str03 &amp; str03 &amp; str2 &amp; str03 &amp; str3
  
  End Sub
  </code></pre>